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