find min in one row return value from another

I would like to find the minimum of my numbers in row 2 and return the value from row 1 that is in the same column as the minimum number.

Ex.

A B C D E F G
R1 9 8 7 6 5 4 3
R2 5 3 4 7 1 2 6

So my formula would need to look at R2 find one and return 5. Is that possible?

Thanks,

Josh

Worked great. I edited it to where if any of the cells are blank or zero it will not use them. Here is the edited

{=INDEX($B$23:$K$23,MATCH(MIN(IF(B29:K29>0,B29:K29)),B29:K29,0))}

Thanks very much


Josh

Josh,
I found this forum and your post was at the top of the list when I logged on. This was exactly what I was looking for! But I can't get it to work, it still returns zero if a cell is blank

=INDEX($C$6:$E$6,MATCH(MIN(IF(C22:E22>0,C22:E22)),C22:E22,0))

any idea what I'm doing wrong?

The formula needs to be confirmed with CTRL+SHIFT+ENTER

To do that select cell with formula, press F2, hold down CTRL and SHIFT keys and then press ENTER so that curly braces like { and } appear around the formula in the formula bar.

Daddylonlegs,
Thanks, that did it. I have never heard of confirming a formula before.

I had figured out a different way to get it to work;

=INDEX(C6:E6,MATCH(SMALL(C22:E22,COUNTIF(C22:E22,0)+1),C22:E22,0))

I didn't need to confirm it that way, whats the diference?