Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i vlookup left? | Excel Discussion (Misc queries) | |||
'RIGHT', 'LEFT' in a VLOOKUP | Excel Discussion (Misc queries) | |||
vlookup left | Excel Worksheet Functions | |||
VLOOKUP LEFT VS RIGHT | Excel Worksheet Functions | |||
VLOOKUP *Left* Value | Excel Discussion (Misc queries) |