Forum Discussion
simple VLOOKUP not working
could you please help me with this one? Why is this VLOOKUP function not working?
It should return 10 instead of 2
Thanks!
=VLOOKUP(B12,A1:B9,2,FALSE) Vlookup works when you specify that you want an exact match.
If you are not looking for an exact match, values in 1st column of matrix have to be sorted in ascending order. If you enter formula: =VLOOKUP(B12,A1:B9,2) Excel assumes that you don't want an exact match. As you range A1:A9 is not sorted in ascending order, vlookup doesn't work.
2 Replies
=VLOOKUP(B12,A1:B9,2,FALSE) Vlookup works when you specify that you want an exact match.
If you are not looking for an exact match, values in 1st column of matrix have to be sorted in ascending order. If you enter formula: =VLOOKUP(B12,A1:B9,2) Excel assumes that you don't want an exact match. As you range A1:A9 is not sorted in ascending order, vlookup doesn't work.
- Thank you so much!!! 🙂
