modify vlookup

C

cuffie

=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.
 
N

Niek Otten

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

--
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.
 
C

cuffie

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

--
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.
Click to expand...
 
Top