left vlookup with max
 

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
--
thanks

left vlookup with max
 

One way
In say, T2: =INDEX(P2:P10,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" wrote:
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
--
thanks

left vlookup with max
 

thank you Max


"Max" wrote:

One way
In say, T2: =INDEX(P2:P10,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" wrote:
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
--
thanks