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

Hi Carlos,

Does this work?

=INDEX(B2:B6,MATCH(MIN(F2:F6),F2:F6,0))

Ken Johnson

How about something like this:
=OFFSET(B2,MATCH(MIN(F2:F6),F2:F6,0)-1,0)


"Carlos Antenna" wrote:

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

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

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

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

How about that!

I've done something right for a change!

Thanks for that JLatham:-)

Also, thanks to Carlos for the feedback.

Ken Johnson