Thread: modify vlookup
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
cuffie cuffie is offline
external usenet poster
 
Posts: 6
Default modify vlookup



"Niek Otten" wrote:

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