Having run a vlookup i am getting the return value of "N/a" wherever a
value is not found.

Is there a way i can get this to read '0' or '-' instead as it effects
later formulae and sum functions.

Many thanks


---
Message posted from http://www.ExcelForum.com/