View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
richzip richzip is offline
external usenet poster
 
Posts: 74
Default Lookup multiple values

On one worksheet, I have a "table" with a header column & header row, along
with data. ON another worksheet, I would like all of the data in the first
worksheet to be in a list; the applicable column header would be placed into
one column, the row header into another one. Example:

Table on first worksheet:

A X P
1 2100 2101 2102
2 2103 2104 2105
3 2106 2107 2108

Desired results on 2nd worksheet:

A B C
2100 1 A
2101 1 X
2102 1 P
2103 2 A
2104 2 X
2105 3 P