Vlookup

[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!!!!

 

[Frank Kabel]

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

 

[Domenic]

Hi,

Try,

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

Hope this helps!

 

[Ian]

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.