Formula help with certain ranges (sumproduct maybe)

[daniels012]

I have 4 results of data which are results of a rank formula.

I need in cell E32 a formula.
I need to find in range AB2:AB5 the value 1 and then give me the result of the corresponding name on the same row from range B2:B5

So whichever cell in AB2:AB5 has a one (ie: AB4) then the name in B4 would be displayed in E32 (where the formula is).

Thank You,
Michael D

 

[Jonmo1]

Try

=INDEX(B2:B5,MATCH(1,AB2:AB5,0))

 

[daniels012]

Very nice.
Thank You,
Michael D

 

[Jonmo1]

Glad to help.. Thanks for the feedback.