cell referencing and looping

[chemmiah]

hello all i have been trying to figure this one out for a while and maybe i am just an idiot:
let's say i have the following"

Bob(a1) 2(b1)
Sarah(a2) 3(b2)
Linda(a3) 1(b3)
George(a4) 5(b4)
Mark(a5) 4(b5)

1(a10)
2(a11)
3(a12)
4(a13)
5(a14)

I want to return a function in b10 (and eventually in b11:b14) that states the following: if b1=1 return the text in a1 if not then move to b2 and do the same until the b cell is equal to 1. Does this make sense?
Chemmiah

[vinaysri11]

Hi,

I created a formula using Indirect and Address functions in the attached file.

Please let me know, if this match your requirement?

[mikerickson]

This might do it.

=INDEX(A:A,MATCH(B:B,1,0),1)

[chemmiah]

Thanx all that is exactly what i need, wow the help on here is amazing!