Indirect function ?

C

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?
 
K

Ken Johnson

Hi Carlos,

Does this work?

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

Ken Johnson
 
J

JLatham

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 said:
Both solutions worked perfectly.

Thanks to you both.
Click to expand...
 
K

Ken Johnson

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

How about that!

I've done something right for a change!

Thanks for that JLatham:)

Also, thanks to Carlos for the feedback.

Ken Johnson
 
Top