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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula Question 4
Can I add a formula or function to Vlookup? 1
Need help modifying code 0
Vlookup and Countif 0
wildcard in IF function 5
need held for auto date calculation for adding years and substract 1
Loop through pages and insert header image 0
Vlookup to return 0 instead of NA 1

Top