Look Up Help!

[Eric H]

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?

 

[T. Valko]

Try this:

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

Copy down as needed.

 

[Eric H]

No luck... (??)

Try this:

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

Copy down as needed.

 

[T. Valko]

Sheet1:

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

A10 = Code2

=INDEX(Sheet1!A$1$1,MATCH(A10,Sheet1!A$1$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.