try this where g is your a and h is your b

=INDEX(G:H,MATCH(MIN(H:H),H:H,0),1)

--
Don Guillett
SalesAid Software

"Bert" wrote in message
...
If I got the following in my excelsheet:
A B
1 20 #VALUE!
2 35,77708764 38683,28157
3 50 31260

I want to sort out the lowest value in the B column and type the value of
the corresponding A column. In this case I want to get the function to
find
B3 as min and type (=A3) in another cell.

Thanks