No problem?
Does that mean it solved your problem? :-)
or it did not work? :-(

"Thomas M." wrote:

No problem.

--Tom

"Sheeloo" <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote in
message ...
Try
=INDIRECT("R1C"&MATCH(MAX(A2:Z2),A2:Z2,0),FALSE)

Change Z to the last column in your range...
This assumes that your data is in row 1 and 2...

Sorry for giving you the wrong solution yesterday... I forgot about the
sorting requirement for LOOKUP...

Thanks to Biff for his inputs.

"Thomas M." wrote:

=INDEX(A1:C1,MATCH(MAX(A2:C2),A2:C2,0))

If there is more than one instance of MAX the formula will match the
leftmost instance.

Works great. It is likely that there WILL be more than one instance of
the max value in the range, but I can deal with that using a text
disclaimer or something.

I ended up adding another formula that uses an IF statement to display a
text message if the max value occurs in the range more than once, and
displays nothing otherwise. I formatted that cell in red so that it
grabs
attention when the message appears.

--Tom