modify vlookup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cuffie - 06 Nov 2006 12:15 GMT

=VLOOKUP(A19,Product!A7:B13,2,FALSE) I need to modify this formula so the if
no in formation is entered in A19 it remains blank. I am currently getting
#na.

Reply to this Message

Niek Otten - 06 Nov 2006 12:38 GMT

=IF(A19="","",VLOOKUP(A19,Product!A7:B13,2,FALSE))

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| =VLOOKUP(A19,Product!A7:B13,2,FALSE) I need to modify this formula so the if
| no in formation is entered in A19 it remains blank. I am currently getting
| #na.

Reply to this Message

cuffie - 07 Nov 2006 20:13 GMT

> =IF(A19="","",VLOOKUP(A19,Product!A7:B13,2,FALSE))
>
> | =VLOOKUP(A19,Product!A7:B13,2,FALSE) I need to modify this formula so the if
> | no in formation is entered in A19 it remains blank. I am currently getting
> | #na.

Reply to this Message

cuffie - 07 Nov 2006 20:14 GMT

Thank you, I will try it.

Reply to this Message

yusuf - 30 Oct 2007 15:30 GMT

IF(ISNA(VLOOKUP(A19,Product!A7:B13,2,FALSE)),0,VLOOKUP(A19,Product!A7:B13,2,FALSE))

> =VLOOKUP(A19,Product!A7:B13,2,FALSE) I need to modify this formula so the if
> no in formation is entered in A19 it remains blank. I am currently getting
> #na.

Reply to this Message

T. Valko - 30 Oct 2007 18:52 GMT

Shorter:

=IF(A19="","",VLOOKUP(A19,Product!A7:B13,2,0))

Signature

Biff
Microsoft Excel MVP

> IF(ISNA(VLOOKUP(A19,Product!A7:B13,2,FALSE)),0,VLOOKUP(A19,Product!A7:B13,2,FALSE))
>
[quoted text clipped - 3 lines]
>> getting
>> #na.

Reply to this Message