G
Guest
I am trying to use an IF function with a VLOOKUP function to correct for an
#N/A result.
The VLOOKUP formula I am using is
=VLOOKUP(A4,'[TRAVEL MANIFEST_Master.xls]Sheet1'!$A$2:$Q$66,8,FALSE).
I want to also use an IF formula that says "if my VLOOKUP function yields a
#N/A result, it should indicate "PENDING". I don't want my spreadsheet to
have a bunch of #N/A in the cells. Can this be done?
Thanks!
#N/A result.
The VLOOKUP formula I am using is
=VLOOKUP(A4,'[TRAVEL MANIFEST_Master.xls]Sheet1'!$A$2:$Q$66,8,FALSE).
I want to also use an IF formula that says "if my VLOOKUP function yields a
#N/A result, it should indicate "PENDING". I don't want my spreadsheet to
have a bunch of #N/A in the cells. Can this be done?
Thanks!