Vlookup formula

D

dculver

I am doing a Vlookup, when it comes to one of my lookups where there is
no colum index for that lookup value it returns #N/A. How can I get it
to return, when there is no information, a 0?
 
G

Guest

Hi
Check you PC time - I think it's a bit out!
Try this format:
=IF(ISERROR(yourVLOOKUP),0,yourVLOOKUP)

Hope this helps.
Andy.
 
Top