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

employee	location1	location2	location3	location4	location5	location5	location6	location7	location8	location10	location11	totals	LOCATION OF MAX
JON DOE1	5	0	0	0	1	1	2	0	0	0	0	9	location1
JON DOE2	1	0	0	0	7	8	1	9	0	1	2
JON DOE3	2	1	0	0	0	4	0	0	0	0	0
JON DOE4	6	1	1	1	2	0	12	0	0	1	1
JON DOE5
JANE DOE8
JANE DOE1
JANE DOE2
JANE DOE3
JANE DOE4
JANE DOE6

<tbody>
</tbody>

 

[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