#N/A error on VLOOKUP
-
-
-
Re: #N/A error on VLOOKUP
VLOOKUP formula does not work if your data is sorted in ascending order.
-
Re: #N/A error on VLOOKUP
VLOOKUP formula works only if your data is sorted in ascending order
-
Re: #N/A error on VLOOKUP
Its okay thanks - the order is fairly random - but the following (a bit complex as it looks) has put it right - I'm guessing its cos the check for the #N/A error is coming first.
Code=IF(C3="","",(IF(ISNA(C3=(VLOOKUP(C3,MYLIST,1,FALSE))),"NO",IF(C3=(VLOOKUP(C3,MYLIST,1,FALSE)),"YES"))))
Bob
-
Re: #N/A error on VLOOKUP
Quote from AkrVLOOKUP formula works only if your data is sorted in ascending order
This is correct only if you do not use the optional 4th arguement and set it to 0 or FALSE. In this case, VLOOKUP looks for an exact match and when it does not find it, it returns the dreaded "#N/A"
-
-
Re: #N/A error on VLOOKUP
Hi,
Try using ISERROR instead...
=If(ISERROR(VLOOKUP(C3,MYLIST,1,False)),"No","Yes")
Hope this helps
-
Re: #N/A error on VLOOKUP
Actually, I would use ISNA in preference to ISERROR. ISNA returns true only if the underlying function returns #N/A!
ISERROR will return true for all error values, including #REF!, when you might actually want to be informed of the error.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!