Just trap it with an IF(ISNA(...) construct, indicatively like this:
=IF(ISNA(vlookup(...)),"",vlookup(...))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"rexmann" wrote:
Is there a way to set the excel column so it does not display the #N/A

I have a spreadsheet with a V-look up ready to calculate when the user
enters the details but until this happens it comes up with a little green
triangle and a #N/A - where I want it to remain blank

Any suggestions greatly appreciated