Formula to return row headers

[hooper12345]

Could someone point me to a post that previously address this (can't locate) or assist me with the following:

I'm trying to return the row header for the lowest value in the set. Using the table below what i'd like to display where the XX is would be "Changed" and "Dated". I'm struggling with the right order of INDEX and MATCH to get this to work.


thank you for the help in advance,

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A1[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]lowest[/TD]
[TD]60%[/TD]
[TD]40%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]XX[/TD]
[TD]XX[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]bundle[/TD]
[TD]4N[/TD]
[TD]5N[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Changed?[/TD]
[TD]60%[/TD]
[TD]100%[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Dated?[/TD]
[TD]100%[/TD]
[TD]40%[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Visual Check?[/TD]
[TD]100%[/TD]
[TD]100%[/TD]
[/TR]
</tbody>[/TABLE]

 

[Marcílio_Lobão]

hooper12345, Good evening.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A
[/TD]
[TD="align: center"]B
[/TD]
[TD="align: center"]C
[/TD]
[/TR]
[TR]
[TD="align: center"]1
[/TD]
[TD]lowest[/TD]
[TD]60%[/TD]
[TD]40%[/TD]
[/TR]
[TR]
[TD="align: center"]2
[/TD]
[TD][/TD]
[TD]=formula[/TD]
[TD]=formula[/TD]
[/TR]
[TR]
[TD="align: center"]3
[/TD]
[TD]bundle[/TD]
[TD]4N[/TD]
[TD]5N[/TD]
[/TR]
[TR]
[TD="align: center"]4
[/TD]
[TD]Changed?
[/TD]
[TD]60%[/TD]
[TD]100%
[/TD]
[/TR]
[TR]
[TD="align: center"]5
[/TD]
[TD]Dated?[/TD]
[TD]100%[/TD]
[TD]40%[/TD]
[/TR]
[TR]
[TD="align: center"]6
[/TD]
[TD]Visual Check?[/TD]
[TD]100%[/TD]
[TD]100%[/TD]
[/TR]
</tbody>[/TABLE]

Try to use:

B2 --> =INDEX(A4:A6, MATCH(MIN(B4:B6), B4:B6, 0))

C2 --> =INDEX(A4:A6, MATCH(MIN(C4:C6), C4:C6, 0))

OR

B2 --> =LOOKUP(MIN(B4:B6), B4:B6, A4:A6)

C2 --> =LOOKUP(MIN(C4:C6), C4:C6, A4:A6)

Is that what you want?
I hope it helps.

 

[hooper12345]

thank you! both work perfectly!

 

[Marcílio_Lobão]

hooper12345, Good afternoon.

Glad to have helped you.

Have a nice day!