BradleyS
Active Member
- Joined
- Oct 28, 2006
- Messages
- 344
- Office Version
- 2010
- Platform
- Windows
I need to find the corresponding column header text, using the ID where there is data in the table cells B2:E9
It doesn't matter what is written in the table cells B2:E9, anything other than blank.
Each ID can ONLY be assigned to 1 column
In the example id 0 should = Shoe
I've tried using INDEX/MATCH, but it doesn't work after the 4th row, which I think is because the lookup sizes need to be the same. In which case what can I use instead?
It doesn't matter what is written in the table cells B2:E9, anything other than blank.
Each ID can ONLY be assigned to 1 column
In the example id 0 should = Shoe
I've tried using INDEX/MATCH, but it doesn't work after the 4th row, which I think is because the lookup sizes need to be the same. In which case what can I use instead?
| Book1 | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | |||
| 1 | id | Hat | Coat | Shoe | Shirt | |||||
| 2 | 4 | a | ||||||||
| 3 | 2 | x | id | 0 | ||||||
| 4 | 7 | y | Answer | #REF! | ||||||
| 5 | 8 | r1 | ||||||||
| 6 | 0 | w | ||||||||
| 7 | 3 | 1 | ||||||||
| 8 | 34 | wg | ||||||||
| 9 | 145 | 54 | ||||||||
Sheet1 | ||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| H4 | H4 | =INDEX(B1:E1,MATCH(H3,A2:A9,0)) |
