Vlookup

  • Thread starter Thread starter Heather
  • Start date Start date
H

Heather

I created a vlookup formula but if an if an item that I am
looking up does not exist I get an #N/A. How do I get it
to be zero?

=VLOOKUP(A8,$D$9:$E$23,2,FALSE)

THANKS!!!!
 
Hi
one way:
=IF(ISNA(VLOOKUP(A8,$D$9:$E$23,2,FALSE)),0,VLOOKUP(A8,$D$9:$E$23,2,FALS
E))
 
Hi,

Try,

=IF(ISNA(VLOOKUP(A8,$D$9:$E$23,2,FALSE)),0,VLOOKUP(A8,$D$9:$E$23,2,FALSE)
)

Hope this helps!
 
Answer is to Copy/Paste special/Values the contents of
ALL the output cells.
This changes the contents from a reference to a value.
Now use Find/Replace All to change the contents of the
cells with #N/A to 0.

Job done.
 
Back
Top