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?
Bookmarks