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?