How to find a content of a cell in the same row with minimum

[RomulusMilea]

Good evening,

Please help me to solve following riddle: in column M I have 10 formulas calculating something and their minimum value is in a certain row. What I need is a formula able to find what is written in the row where minimum value can be found, but in column D. How can I resolve this ? Thank you again for your consistent help.

 

[lenze]

Hello

Look at the formula in D11. It returns the Value in Column D opposite the Min of Column G. Hope this helps. (You may have a problem if the Min occurs in two places as it return only the first occurance))

Book1
	A	B	C	D	E	F	G
1	4	5		xxxx			9
2	3	6		yyyy			9
3	6	4		zzzz			10
4	2	8		aaaa			10
5	4	3		bbbb			7
6	5	3		cccc			8
7	7	5		dddd			12
8	5	4		eeee			9
9	7	5		fffff			12
10
11				bbbb
12
...

 

[Aladin Akyurek]

On 2002-10-08 11:58, RomulusMilea wrote:
Good evening,

Please help me to solve following riddle: in column M I have 10 formulas calculating something and their minimum value is in a certain row. What I need is a formula able to find what is written in the row where minimum value can be found, but in column D. How can I resolve this ? Thank you again for your consistent help.

=INDEX(D-range,MATCH(MIN(M-range),M-range,0))

Note that this formula will return a D-value that corresponds to the first instance/token of the minimum value from M-range.