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!