Thanks to Norman, tolgag and Bob.


"___Zoom" wrote in message
...
How can we hide displaying "#N/A" false indicator becasue of the normal
function of VLOOKUP formula in a cell without disturbing its operation?.

My formula stands like this at Sheet1!A1:
=VLOOKUP(A1;Sheet2!A:C;2;FALSE)

and when Sheet1!A1 is empty naturally I get a "#N/A" display.
I want NO error messages displayed when the cell is empty.
Can anyone comment?
TIA