Thread: modify vlookup
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default modify vlookup

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"cuffie" wrote in message ...
| =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.