Difference between Vlookup returning 0 and #n/a?

Viewed 8105

I was wondering why my Vlookup function will sometimes return 0 and sometimes return #N/A when it is unable to find the value.

I know how to work around this but was just curious as to why it doesn't return all #N/A's or all zeroes

Thank you!

0 Answers
Related