Forum Discussion

Kong08's avatar
Kong08
Copper Contributor
Jul 26, 2022
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 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!

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

     

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

     

Resources