Forum Discussion
Kong08
Jul 26, 2022Copper Contributor
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 3 or 4 or 5
B3 = 0.1 or 0.2 or 0.3 or 0.4 or 0.5
IF B2=1 and B3=0.1 then B4=2020
IF B2=2 and B3=0.5 then B4=2021
There is no correlation between the numbers in B2 and B3 but the answer in B4 is predefined based on the options selected in the 2 categories.
It appears B4 requires multiple IF formulas in the same cell but not sure how to write this correctly.
Please help!
=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.
- OliverScheurichGold Contributor
=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.
- Kong08Copper ContributorThank you!!!