You could use ISNA to trap just #N/A errors, eg:
=IF(ISNA(Vlookup),0,Vlookup)
Above presumes you wish to be kept informed should errors other than #N/A
arise
--
Max
Singapore http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.