Forum Discussion
Solved
Excel Multiple Conditions Formula
Hi, Hoping for some help with the below query: There are 2 different categories and 5 options in each. These options combined determine the answer in a separate cell. I.e B2 = 1 or 2 or ...
=INDEX($F$4:$J$8,MATCH(B2,$E$4:$E$8,0),MATCH(B3,$F$2:$J$2,0))You can try this formula for the data layout of the example.
=INDEX($F$4:$J$8,MATCH(B2,$E$4:$E$8,0),MATCH(B3,$F$2:$J$2,0))You can try this formula for the data layout of the example.
- Thank you!!!
