Ken's is probably a little more efficient and understandable since it does
away with the need to subtract one from the results.

"Carlos Antenna" wrote:

Both solutions worked perfectly.

Thanks to you both.

--
Carlos

"Carlos Antenna" wrote in message
...
I want a formula to look at range F2:F6 and pick the min value and then
return the value from column B in the same row.

I've been trying to combine INDIRECT, ROW and MIN, but I can't seem to get
it working.

Can anyone help?

--
Carlos