Find the highest then lookup result

[Stalker]

Morning all,

In row 3 of my worksheet, i have the following data:

B3 -> "Style 1"
C3 -> (a number ranging from 1-18)
D3 -> "Style 2"
E3 -> (a number ranging from 1-18)
F3 -> "Style 3"
G3 -> (a number ranging from 1-18)
H3 -> "Style 4"
I3 -> (a number ranging from 1-18)

I would like a formula that will look at the values in C3, E3, G3, I3 - find the highest numerical value and then return the text value that is in the cell to its left.

for example:

C3 = 2
E3 = 7
G3 = 3
I3 = 6

So the formula would see 7 (E3) as the highest, and return the text value to its left (D3) "Style 2"

The formula will be in cell D2
Kind regards

[Ms-Excel-User]

Hi,
Try this =OFFSET(B3,0,MATCH(MAX(B3:I3),B3:I3,0)-2)

[Kevin@Radstock]

Hi Stalker

The INDEX & MATCH will achieve this for you.

=INDEX($B$3:$I$3,MATCH(LARGE(B3:I3,1),B3:I3,0)-1)

[Stalker]

Hi Both,

Thank-you very much for the input, i have tried both and they give me the same result!

Rep addeed, thanks alot

[princ_wns]

Hi Dear,

You may also try this one...

=VLOOKUP(MAX(C3:J3),C3:J3,MATCH(MAX(C3:J3),C3:J3,0 )+1)

Regards
Prince