Forum Discussion

Copper Contributor

Mar 01, 2023

Formula Help in Excel

I need help --- I am down to the last issue. Please help with any suggestions to resolve example #2 below. Thanks!!!!! General Information: Cell A722 = Brad Cell B722 = 1233 Svc Code Cell ...

excel

balopez66

Copper Contributor

Mar 01, 2023

Thank you so much for your knowledge:
Modified formula:
=IFS(A723="Barb",VLOOKUP(B723,Kelly,11,FALSE),A723="Betty",VLOOKUP(B723,Kelly,11,FALSE),A723="Bridget",VLOOKUP(B723,Kelly,13,FALSE),A723="Brad",VLOOKUP(B723,Kelly,12,FALSE),IFNA(VLOOKUP(B723,Kelly,12,False),"")

This gives me "The Formula is missing an opening or closing parenthesis".

FikturFox

Brass Contributor

Mar 01, 2023

balopez66

Your formula should be modified like this:

=IFS(
A723="Barb", IFNA(VLOOKUP(B723,Kelly,11,FALSE),""),
A723="Betty", IFNA(VLOOKUP(B723,Kelly,11,FALSE),""),
A723="Bridget", IFNA(VLOOKUP(B723,Kelly,13,FALSE),""),
A723="Brad", IFNA(VLOOKUP(B723,Kelly,12,FALSE),""),
TRUE,"No Match")