JeffGrant
Well-known Member
- Joined
- Apr 7, 2021
- Messages
- 516
- Office Version
- 365
- Platform
- Windows
Can somebody please tell me why this simple Index/Match isn't working. I can't seem to see the forest for the trees
Please note that this is entered as an array formula.
Thanks for your patience
Book1 | |||||||||
---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | |||
2 | 1 | 2 | 3 | ||||||
3 | 1 | a | b | c | Column Look Up | 1 | |||
4 | 2 | d | e | f | Row Look Up | 1 | |||
5 | 3 | h | i | j | Result | #N/A | |||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
H5 | H5 | =INDEX(C3:E5,MATCH(1,(H3=C2:E2)*(H4=B3:B5),0)) |
Press CTRL+SHIFT+ENTER to enter array formulas. |
Please note that this is entered as an array formula.
Thanks for your patience