modify vlookup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=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.
 
=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.
 
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...
 
IF(ISNA(VLOOKUP(A19,Product!A7:B13,2,FALSE)),0,VLOOKUP(A19,Product!A7:B13,2,FALSE))
 
You must log in or register to reply here.

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

EXCEL - IF(IFERROR(VLOOKUP question 0
Formula Question 4
need held for auto date calculation for adding years and substract 1
wildcard in IF function 5
FORMULA TO DELETE A ROW IN LINKED SHEETS 1
Help with IF, AND & OR statements... 4
VLOOKUP combined with AND 4
MedianIf multiple range and criteria 5

Back
Top