View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Arla
 
Posts: n/a
Default #N/A in VLookup - Can I use another function that will return 0?

I am using a VLookup function. I need to find an exact match, but when there
is no match, I would like to see a zero, rather than #N/A. Can someone help
me with a different formula to produce similar results as I am getting with
the VLookup without the #N/A?