SOLVED

Excel Multiple Conditions Formula

New Contributor

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!

2 Replies
best response confirmed by Kong08 (New Contributor)
Solution

@Kong08 

=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.

multiple condition formula.JPG 

Thank you!!!