| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
