Forum Discussion

Rebecca_Schemm's avatar
Rebecca_Schemm
Copper Contributor
Mar 18, 2024

Excel Advanced formula Assistance

=IF(A2="Complete",B2,"")

however, if B2 is blank then want to return C2, and if C2 is Blank want to return D2

tried nesting =IF(AND formulas.. nothing is working

  • Rebecca_Schemm 

    If it's just those cells:

    =IF(A2="Complete", IF(B2="", IF(C2="", D2, C2), B2), "")

    If you want to return the first non-blank cell to the right of A2 (B2 or C2 or D2 or E2 or ..., up to for example Z2):

    =IF(A2="Complete", IFERROR(INDEX(B2:Z2, MATCH(TRUE, B2:Z2<>"", 0)), ""), "")

  • Rebecca_Schemm 

    If it's just those cells:

    =IF(A2="Complete", IF(B2="", IF(C2="", D2, C2), B2), "")

    If you want to return the first non-blank cell to the right of A2 (B2 or C2 or D2 or E2 or ..., up to for example Z2):

    =IF(A2="Complete", IFERROR(INDEX(B2:Z2, MATCH(TRUE, B2:Z2<>"", 0)), ""), "")

Resources