try this where match,0 finds the 1st instance of max, match finds the row
and offset(row,whatever column)

=OFFSET(A1,MATCH(MAX(A:A),A:A,0),1)

--
Don Guillett
SalesAid Software

"Peters" wrote in message
...

Hello,

I am encountering problems with de VLOOKUP function. I have a database
with prices and company names. I have calculated the max. price per
product and now i want the name of the company to appear in the next
colum, how can i do that?

Pls help me!

Thx,

Peter


--
Peters
------------------------------------------------------------------------
Peters's Profile:
http://www.excelforum.com/member.php...o&userid=16859
View this thread: http://www.excelforum.com/showthread...hreadid=320444