Vlookup - what I am doing wrong?

[Lee733]

Cell C13 has the formula =Vlookup(B13,F5:AQ12,1) - correct result of 8 is returned,
Cell C14 has the forumla =Vlookup(B14,F5:AQ12,1) - incorrect result of 8 is returned. It should be 7. Why is this not working?

 

[Lee733]

=match(B14,L5:L12,0)

 

[Joe4]

That formula is matching column B to column L. Your original VLOOKUP was trying to match column B to column F.
You cannot use VLOOKUP to do that, as with a VLOOKUP, the column you are matching on HAS to be the first column (left-most) in your lookup range (in the second argument).
You cannot return columns to the left of the column you are matching on.

However, if you have a newer version of Excel (Excel 365 or 2021), you can use XLOOKUP, i.e.

=XLOOKUP(B14,L5:L12,F5:F12,0)

 

[Lee733]

Thank you very much, I really appreciate it.

 

[Joe4]

You are welcome.

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)