max or large function

[Guest]

Hi,
I have data in column J, associate with column I, data in column M,
assoicated with coumn L, and data in column P, assoicated with coumn O. I
need to find the large or max of J,M,P then it puts the corresponding info
from where the max is from column I, L, O. How would I do this? For ex:

ABC 1 DEF 6 FGH 3

So in this case the formula find the max, which is 6, then gives me DEF
because that is data next to it. Thanks.

 

[Guest]

With
I1: abc
J1: 1
L1: def
M1: 6
O1: fgh
P1: 3

Here are a couple options

Q1: =IF(J1=MAX(J1,M1,P1),I1,IF(M1=MAX(J1,M1,P1),L1,IF(P1=MAX(J1,M1,P1),O1)))

or
R1: =MAX(J1,M1,P1)
Q1: =IF(J1=R1,I1,IF(M1=R1,L1,IF(P1=R1,O1)))

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[Bob Phillips]

=INDEX(I1:O1,MATCH(MAX(J11),J11,0))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Yep, that did it. Thanks!

With
I1: abc
J1: 1
L1: def
M1: 6
O1: fgh
P1: 3

Here are a couple options

Q1: =IF(J1=MAX(J1,M1,P1),I1,IF(M1=MAX(J1,M1,P1),L1,IF(P1=MAX(J1,M1,P1),O1)))

or
R1: =MAX(J1,M1,P1)
Q1: =IF(J1=R1,I1,IF(M1=R1,L1,IF(P1=R1,O1)))

Does that help?
***********
Regards,
Ron

XL2002, WinXP