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