Thread: HLookup question

Any help would be greatly welcome.

I'm trying to use the Hlookup function and think I'm doing something wrong but I can't figure out what.

Row 1 contains a series of numbers
Rows 2 - 385 also contain a series of numbers

I'm trying to search for the largest number in each row from row 2 on and then kickout the number in row 1 that is in the same column as the maximum value in each remaining row.

For example (Commas separating values)

Row 1
1,2,3

Row 2
1888, 454, 577

Row 3
666, 999, 35860

I would want to report "1" for row 2 and "3" for row 3 with hlookup

I've been trying to use this for row 2:

=HLOOKUP(MAX(A2:C2),$A$1:$C$3,1)

And this for row 3:

=HLOOKUP(MAX(A3:C3),$A$1:$C$3,1)

But I keep kicking out "3" as the value for both

Thoughts?

Originally Posted by arthurbr

Please post in the appropriate forum. This is an XL question I gather?

I will move it for you this time

Thank you so much for moving the thread. I thought I had placed it in the most appropriate forum but I see I was wrong. Sigh.

Daddylonglegs: The index function worked great!

Thanks for all the help =)