Select cell in range based on min in another

[cliff brock]

I have a range (r3:t3). I want to select one of the cells in that range based on the minimum in another range (r11:t11). r3:t3 is text, and r:11:t11 is numeric. Conditional formatting in r11:t11 gives me a red (255) on lowest number in the range, so I could select by MIN or interior.color. Which should I use and how? Thanks.

[#2 · Accepted solution]

@cliff brock 

=INDEX(R3:T3,MATCH(MIN(R11:T11),R11:T11,0))

[#3]

thanks, hans. second time in a year i have not thought of index/match. i am kicking myself.