Need some hlookup help

[hissonrr]

Good day all,

Having some trouble finding a solution to this.

have a table like the below...

Basically what I need to do is add a column D, that has a formula that looks horizontally down the row, and returns the formation that has the highest percentage in that row.

For example D1 would = Formation C, D2 would = Formation B, D3 would = Formation A, ect...

What formula would I need for column D?

Couldn't figure it out with my limited skills, any help would be appreciated.

I

	A	B	C
Lease	Formation A	Formation B	Formation C
Lease A	40%		60%
Lease B		90%	10%
Lease C	80%	10%	10%

 

[jasonb75]

Something like this

Book1
	A	B	C	D	E
1	Lease	Formation A	Formation B	Formation C
2	Lease A	40%		60%	Formation C
3	Lease B		90%	10%	Formation B
4	Lease C	80%	10%	10%	Formation A
Sheet17

Cell Formulas
Range	Formula
E2:E4	E2	=XLOOKUP(MAX($B2:$D2),$B2:$D2,$B$1:$D$1)

 

[JEC]

Just use MAX icm a lookup

 

[hissonrr]

Something like this

Book1
	A	B	C	D	E
1	Lease	Formation A	Formation B	Formation C
2	Lease A	40%		60%	Formation C
3	Lease B		90%	10%	Formation B
4	Lease C	80%	10%	10%	Formation A
Sheet17

Cell Formulas
Range	Formula
E2:E4	E2	=XLOOKUP(MAX($B2:$D2),$B2:$D2,$B$1:$D$1)

Perfect thank you!