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?