Forum Discussion
simple VLOOKUP not working
=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.
=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.
