VLOOKUP returns 0 (zero) when lookup cell is blank
Thank you both!
--
Maki @ Canberra.AU
"T. Valko" wrote:
Try this:
=IF(VLOOKUP(.....)="","",VLOOKUP(.....))
--
Biff
Microsoft Excel MVP
"Maki" wrote in message
...
When the cell that VLOOKUP looked-up is blank, it displays 0 (zero).
How can I prevent this and make it to not show anything? i.e. blank?
--
Maki @ Canberra.AU
|