Look Up Help!
 

Hello,
I have a table in worksheet 1 with Product Codes in every other column (A,
C, E, etc) and data related to those Product Codes residing in the adjacent
column (B, D, F etc).
I have another table on worksheet 2 where I have like Product Codes residing
all in column A. I want to be able to return cooresponding data into column
G of worksheet 2 from the data columns (B, D, F, etc) from worksheet 1.

How do I achieve this?

Look Up Help!
 

Try this:

=INDEX(Sheet1!A$1:H$1,MATCH(A1,Sheet1!A$1:H$1,0)+1 )

Copy down as needed.

--
Biff
Microsoft Excel MVP


"Eric H" wrote in message
...
Hello,
I have a table in worksheet 1 with Product Codes in every other column (A,
C, E, etc) and data related to those Product Codes residing in the
adjacent
column (B, D, F etc).
I have another table on worksheet 2 where I have like Product Codes
residing
all in column A. I want to be able to return cooresponding data into
column
G of worksheet 2 from the data columns (B, D, F, etc) from worksheet 1.

How do I achieve this?

Look Up Help!
 

No luck... (??)

"T. Valko" wrote:

Try this:

=INDEX(Sheet1!A$1:H$1,MATCH(A1,Sheet1!A$1:H$1,0)+1 )

Copy down as needed.

--
Biff
Microsoft Excel MVP


"Eric H" wrote in message
...
Hello,
I have a table in worksheet 1 with Product Codes in every other column (A,
C, E, etc) and data related to those Product Codes residing in the
adjacent
column (B, D, F etc).
I have another table on worksheet 2 where I have like Product Codes
residing
all in column A. I want to be able to return cooresponding data into
column
G of worksheet 2 from the data columns (B, D, F, etc) from worksheet 1.

How do I achieve this?

Look Up Help!
 

Sheet1:

...........A..........B..........C..........D
1....Code1.....C1.....Code2.....C2

A10 = Code2

=INDEX(Sheet1!A$1:D$1,MATCH(A10,Sheet1!A$1:D$1,0)+ 1)

Returns C2

That's how I interpret your layout. If that's not correct then describe in
more detail how your data is laid out.


--
Biff
Microsoft Excel MVP


"Eric H" wrote in message
...
No luck... (??)

"T. Valko" wrote:

Try this:

=INDEX(Sheet1!A$1:H$1,MATCH(A1,Sheet1!A$1:H$1,0)+1 )

Copy down as needed.

--
Biff
Microsoft Excel MVP


"Eric H" wrote in message
...
Hello,
I have a table in worksheet 1 with Product Codes in every other column
(A,
C, E, etc) and data related to those Product Codes residing in the
adjacent
column (B, D, F etc).
I have another table on worksheet 2 where I have like Product Codes
residing
all in column A. I want to be able to return cooresponding data into
column
G of worksheet 2 from the data columns (B, D, F, etc) from worksheet
1.

How do I achieve this?