Forum Discussion
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
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)), ""), "")
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)), ""), "")
- THANK YOU!!!!!
