Help: VLOOKUP Function Error

[Jung Bin]

Hi guys,

I am new to excel and having difficulties using vlookup function for the sports day.

I am having a trouble with the vlookup function to get the student name from the table above looking at the record value in the left.
I have attached a file if you want to have a look what the problem is.

Feel free to suggest any other ideas to make it better

[bebo021999]

VLOOKUP can not lookup to the left. Use INDEX instead.

=INDEX($B$4:$B$12,MATCH($A15,Score,0))

[José Augusto]

Hi
use in B15
=INDEX($B$4:$B$12,MATCH(A15,$D$4:$D$12,FALSE),1)

[alansidman]

In B15 use the Index/Match function

=INDEX(B4:B12,MATCH(A15,Score,0))

vlookup only looks to the right.

[ChemistB]

VLOOKUP's always go left to right. You'll need to use something different like INDEX MATCH

One dimensional INDEX/MATCH
=INDEX(Range to Return, MATCH(value, value range, 0 (for exact match)))
So in M10

=INDEX($B$4:$B$12, MATCH(L10,Score,0))
Questions?

[Jung Bin]

Thank you very much all of you, really appreciate it.