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