Indirect function ?

[Carlos Antenna]

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?

 

[Ken Johnson]

Hi Carlos,

Does this work?

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

Ken Johnson

 

[Guest]

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

 

[Carlos Antenna]

Both solutions worked perfectly.

Thanks to you both.

 

[Guest]

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

Both solutions worked perfectly.

Thanks to you both.

 

[Ken Johnson]

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