Help with lookup
Hi,
I assume that table 2 is in the sheet called Table2
=index(Table2!$B$1:$B$10000,match(A2,Table2!$A$1:$ A$10000,0))
"CW" wrote:
Hi Eduardo
Sample data is as follows:
TABLE 1
Date Model Price Exchange Rate
Total
Jan-2004 VW 10,000 .97
970
Jan-2004 Mercedes 10,000 .97
970
Jan-2004 Audi 10,000 .97
970
Feb-2004 VW 10,000 .85
850
Feb-2004 Mercedes 10,000 .85
850
Feb-2004 Audi 10,000 .85
850
TABLE 1
Date
Jan 2004 .97
Feb 2004 .85
The exchange rate isn't currently populated in Table 1 and I need to create
a lookup to pull it in to this column.
Hopefully this makes sense.
Thanks
Carol
"Eduardo" wrote:
Hi,
could you provide an example
"CW" wrote:
Hi
I need to automatically populate a colum in a table with values from a
separate sheet.
e.g. in table 1, I have column headings:
Date; Type; Value 1... (also trying to lookup with new column)
In table two I have:
Date; Value 2
Where the date matches I would like to populate table 1 with Value 2. The
problem I am having is that there are three different 'types' for each date
in table 1.
Could someone please help?
|