simple VLOOKUP not working

[danae1974]

could you please help me with this one? Why is this VLOOKUP function not working?

It should return 10 instead of 2

Thanks!

[#2 · Accepted solution]

@danae1974 

=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.

[#3]

Thank you so much!!! :)