left vlookup with max

[Morgan]

hi there,

i have two columns of data, for example Column P has a description and
Column R has the value, is it possible to find the max value in Col R and
have the corresponding description in Col P displayed in another cell?

there is a one column gap in between, is that going to make a difference?

thank you for your help

 

[Max]

One way
In say, T2: =INDEX(P210,MATCH(MAX(R2:R10),R2:R10,0))
Adapt the ranges to suit. Success? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik

 

[Morgan]

thank you Max

One way
In say, T2: =INDEX(P210,MATCH(MAX(R2:R10),R2:R10,0))
Adapt the ranges to suit. Success? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik