Happy to help. So what's the deal with you speaking of row A? Is that
something about the Chinese version, that they use letters for the rows and
numbers for the columns? Or is there some option in Excel that lets the user
reverse the two, maybe?

--- "rockycho912" wrote:
you've got me with your second problem. I missed the point where excel only
look up the value in the first row. thanx a million. my problem wasn't helped
by the fact that i was using a chinese version of office, which has all the
help files in chinese. even i am fluent in chinese, the guys at microsoft did
a pretty poor job in translating and i hadn't the slightest clue what they
were talking about in the help files. maybe if any microsoft staff reading
this: employ someone who can actually translate properly and proof read again
to see if it made any sense!

--- "Bob Bridges" wrote:
I think you're right in your use of FALSE as the 4th argument. What I see is
another problem, or maybe two others. I use R1C1 notation myself, but it
seems to me you're confusing your rows and columns; you speak of rows A, B
and C, but usually in A1 notation A, B and C refer to columns and rows are
denoted as numbers. Could it be as simple as that? Seems to me your
formula ought to to refer not to MAX(C1:C61) but to MAX(A3:BI3), not A1:C61
but A1:BI3. Or, if you're using R1C1, to MAX(R3C1:R3C61) and R1C1:R3C61.

If so, I see a further problem: HLOOKUP insists on the value you're
searching for - MAX(A3:BI3) - being in the first row of the table, not the
third. If you want to search on the max value in row 3, and return a
corresponding value from row 2, and don't want to rearrange the rows, you
can still do it; you just have to do a MATCH instead of HLOOKUP. Match gives
you the COLUMN NUMBER your max value appeared in - say 33 - which you
can then use with INDIRECT to pull the value in row 33 col 2.

How am I doing so far?