Posted to microsoft.public.excel.newusers
|
|
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
|