Find value 2 columns left of highest value in original column

[markdoughty]

I'm trying to look up the values in a column, find the highest value, then show the value of the cell 2 columns to the left?

=VLOOKUP(LARGE(A:A,1),A1:V500,(0,-2),FALSE)

Ive managed to get the below working to the right but cant get it working to the left?

=VLOOKUP(MAX(M1:M500), A1:V500, 4, FALSE)


All ideas helpful..

 

[texasalynn]

does this work?
=INDEX(K:K,MATCH(MAX(M:M),M:M,0))

 

[texasalynn]

or maybe this?
=OFFSET(INDIRECT("M"&MATCH(MAX(M:M),M:M,0)),0,-2)

 

[markdoughty]

or maybe this?
=OFFSET(INDIRECT("M"&MATCH(MAX(M:M),M:M,0)),0,-2)

The above works a treat, thank you....