=INDEX(C:C,MATCH(MAX(B:B),B:B),0)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Haz" wrote in message
...
HI
I'm using Excel 2003, I'm trying to write a function that will return the
value of a blank cell in cloumn 3 when cloumn 2 has the highest number
entered in it
B C
12
13
14 ( return data entered in this cell here)

I've tried different functions without success.