Using IF function with VLOOKUP

M

MsBeverlee

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!
 
K

KL

=IF(ISNA(MATCH(A4,'[TRAVEL MANIFEST_Master.xls]Sheet1'!$A$2:$Q$66,0)),"",VLOOKUP(A4,'[TRAVEL
MANIFEST_Master.xls]Sheet1'!$A$2:$Q$66,8,0))
=IF(ISERROR(MATCH(A4,'[TRAVEL MANIFEST_Master.xls]Sheet1'!$A$2:$Q$66,0)),"",VLOOKUP(A4,'[TRAVEL
MANIFEST_Master.xls]Sheet1'!$A$2:$Q$66,8,0))
=IF(ISNUMBER(MATCH(A4,'[TRAVEL MANIFEST_Master.xls]Sheet1'!$A$2:$Q$66,0)),VLOOKUP(A4,'[TRAVEL
MANIFEST_Master.xls]Sheet1'!$A$2:$Q$66,8,0),"")
=IF(ISNA(VLOOKUP(A4,'[TRAVEL MANIFEST_Master.xls]Sheet1'!$A$2:$Q$66,8,0)),"",VLOOKUP(A4,'[TRAVEL
MANIFEST_Master.xls]Sheet1'!$A$2:$Q$66,8,0))
=IF(ISERROR(VLOOKUP(A4,'[TRAVEL MANIFEST_Master.xls]Sheet1'!$A$2:$Q$66,8,0)),"",VLOOKUP(A4,'[TRAVEL
MANIFEST_Master.xls]Sheet1'!$A$2:$Q$66,8,0))

--
KL
[MVP - Microsoft Excel]
RU: http://www.mvps.ru/Program/Default.aspx
ES: http://mvp.support.microsoft.com/?LN=es-es
EN: http://mvp.support.microsoft.com/?LN=en-us
Profile: https://mvp.support.microsoft.com/profile=AB32F8EE-8ED3-4AB9-ADDA-9E6C73C09A36
 
Top