Max Value from multiple columns and return item.

[Micka77]

I am trying to find a way to return the max value from Value1 and Value2 along with the relevant item from column 1.
I can make this work with just max value as shown on cell A7.
A8 and A11 work in varying ways, but these are only looking at single columns, surely I’m missing something simple here?

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff New.xlsm
	H	I	J
8	Water	100	30
9	Gas	200	250
10	Electricity	300	900
11	Oil	400	500
12
13
14		Electricity
Main

Cell Formulas
Range	Formula
I14	I14	=XLOOKUP(MAX(I8:J11),I8:I11,H8:H11,XLOOKUP(MAX(I8:J11),J8:J11,H8:H11,,0),0)

 

[Micka77]

Hi & welcome to MrExcel.
How about

+Fluff New.xlsm
	H	I	J
8	Water	100	30
9	Gas	200	250
10	Electricity	300	900
11	Oil	400	500
12
13
14		Electricity
Main

Cell Formulas
Range	Formula
I14	I14	=XLOOKUP(MAX(I8:J11),I8:I11,H8:H11,XLOOKUP(MAX(I8:J11),J8:J11,H8:H11,,0),0)

Fluff thank you so much, that combined with a max formula in the next column gives me what I need. Brilliant.
Thanks for your kind welcome too.
Now I just hope I can change Max to a “Large” formula to return me the top 3 results which I look forward to solving.

 

[Fluff]

You're welcome & thanks for the feedback.