Help with lookup
 

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?

Help with lookup
 

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?

Help with lookup
 

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?

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?