An alternative is to use COnditional Formatting to hide the #N/A
best wishes
--
Bernard Liengme
http://people.stfx.ca/bliengme

"VAP" wrote in message
...
Is there anyway to not display '#n/a' when use a 'vlookup' formula?(or
maybe
display a '0' instead of a 'n/a')