=INDEX(A1:A10,MATCH(MAX(B1:B10),B1:B10,0))

--
Kind regards,

Niek Otten

"prspiderman" wrote in message
...
Hello Gang:
I have two colums, Column A (Val1) and Column B (a number such as 456). If
I use the expression =max(b1:b10) I get the highest value for that column,
but what what I need is the adjacent cell name such as Val1.

Thanks for the help in advance...
--
Rafy Rivera