SOLVED

Copper Contributor

=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

2 Replies
best response confirmed by Rebecca_Schemm (Copper Contributor)
Solution

# Re: Excel Advanced formula Assistance

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)), ""), "")

# Re: Excel Advanced formula Assistance

THANK YOU!!!!!
1 best response

Accepted Solutions
best response confirmed by Rebecca_Schemm (Copper Contributor)
Solution

# Re: Excel Advanced formula Assistance

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)), ""), "")