BradleyS
Active Member
- Joined
- Oct 28, 2006
- Messages
- 351
- 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)) |