Horizontal lookups

[MZING81]

I have never really used an hlookup before, and need a little help, and it is possible that maybe some other formula could be used
I need the formula to find the max number in a row and then extract the text from the row 1 thats directly above it. The table is about 1200 rows, and I'd pull the formula down. The every formula needs pull the text from the same row. The formula will be in the last column "LOCATION OF MAX"

I tried and Index Match but it only pulled the last location. I tried an offset index but that didnt work either.
Any assistance would be greatly appreciated
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]employee[/TD]
[TD]location1[/TD]
[TD]location2[/TD]
[TD]location3[/TD]
[TD]location4[/TD]
[TD]location5[/TD]
[TD]location5[/TD]
[TD]location6[/TD]
[TD]location7[/TD]
[TD]location8[/TD]
[TD]location10[/TD]
[TD]location11[/TD]
[TD]totals[/TD]
[TD]LOCATION OF MAX[/TD]
[/TR]
[TR]
[TD]JON DOE1[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]9[/TD]
[TD]location1[/TD]
[/TR]
[TR]
[TD]JON DOE2[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]1[/TD]
[TD]9[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]JON DOE3[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]4[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]JON DOE4[/TD]
[TD]6[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD]12[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]JON DOE5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]JANE DOE8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]JANE DOE1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]JANE DOE2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]JANE DOE3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]JANE DOE4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]JANE DOE6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[tekanoid]

Try something like this:

=INDIRECT(ADDRESS(1,(MATCH(MAX(B2:L2),B2:L2,0)+1)))

The first "1" is row 1. The "+1" at the end indicates that it should add 1 column to the result of the Match (since your values begin in column 2).

HTH

 

[MZING81]

Try something like this:

=INDIRECT(ADDRESS(1,(MATCH(MAX(B2:L2),B2:L2,0)+1)))

The first "1" is row 1. The "+1" at the end indicates that it should add 1 column to the result of the Match (since your values begin in column 2).

HTH

Thank you I appreciate and look forward to testing it out