Using IF function with VLOOKUP

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MsBeverlee - 11 Mar 2007 22:06 GMT

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!

Reply to this Message

KL - 11 Mar 2007 22:15 GMT

=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))

Signature

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

>I am trying to use an IF function with a VLOOKUP function to correct for an
> #N/A result.
[quoted text clipped - 8 lines]
>
> Thanks!

Reply to this Message