Forum Discussion

jmdarbyshire's avatar
jmdarbyshire
Copper Contributor
Jul 21, 2024

Formula based on a combination of two other cells where the combination varies

Hello forum friends   I need a formula that will look at two other cells and depending on the combination in those cells populate the third cell. For example:   If A1 says Critical and B1 says Hi...
excel
Formulas and Functions
Vinit0412's avatar
Vinit0412
Copper Contributor
Jul 29, 2024

Hi jmdarbyshire 

 

You can use the below formula to perform your task.

=IFERROR(INDEX($G$1:$J$6,MATCH(A1,$G$1:$G$6,0),MATCH(B1,$G$1:$J$1,0)),"")

 

I am attaching the excel file with the same formula.

 

SergeiBaklan's avatar
SergeiBaklan
MVP
Jul 29, 2024

Vinit0412 

It shall return Ongoing into the right cell with any text in the middle cell, not as

  • Vinit0412's avatar
    Vinit0412
    Copper Contributor
    Jul 29, 2024

    Respected Sir, SergeiBaklan 

     

    I got your point.

    It is mentioned in the original post but I think I missed that point.

    Here formula is little bit tweaked as below

    =IFERROR(IF(A17=$G$6,A17,INDEX($G$1:$J$6,MATCH(A17,$G$1:$G$6,0),MATCH(B17,$G$1:$J$1,0))),"Not Available")

     

    I am attaching the excel file with new formula in D column. 

     

Resources