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/

Hi
try the following:
=IF(ISNA(your_vlookup_formula),"-",your_vlookup_formula)

HTH
Frank

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

Hi Ian

Try
=IF(ISERROR(yourformula),0,yourformula))

--
Regards
Roger Govier
"ian123 " wrote in message
...
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/