see http://www.ozgrid.com/Excel/stop-na-vlookup.htm



--
Regards
Dave Hawley
www.ozgrid.com
"Amin" wrote in message
...
i want to stop the #N/A showing in my cells where the VLookup has been used
is it possiblt to stop them from showing when a a lookup value is not yet
available.