I'm getting #N/a but i want 0 or '-'

  • Thread starter Thread starter ian123
  • Start date Start date
I

ian123

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
try the following:
=IF(ISNA(your_vlookup_formula),"-",your_vlookup_formula)

HTH
Frank
 
You must log in or register to reply here.

Ask a Question

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.

Ask a Question

Similar Threads

GetSystemMetrics32(n) Question 3
Set add function ignore #N/A 1
Sum Function When Formula Produces #N/A 2
Returning result as 0 from #N/A 7
lookup folmula i/e n/a 10
#N/A Conversion 8
VLOOKUP & ISNA 2
how to conver #n/a's to 0 6

Back
Top