=IF(MATCH(MIN(21:21),21:21,0)1,INDEX(21:21,MATCH( MIN(21:21),21:21,0)-1),"")

--
HTH

Bob Phillips

"Alex_Werner" wrote in message
...
I have a huge spread sheet, in which I need to extract the value from the
cell, which sits right to the lowest value in the whole row. E.g.:
Example row: 2|4|7|3|0.3|10
Expected extract value: 3
I was thinking of using the OFFSET functionality in combination with the
MIN
functionality: =OFFSET(MIN(A1:A6),,-1) However, this is not working.
Anybody
any idea why not? Or a better solution at all?