Excel Multiple Conditions Formula

[Kong08]

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 · Accepted 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.

 

[#3]

Thank you!!!