Hi,

There is another way to do this. Array entert the following formula
(Ctrl+Shift+Enter)

Enter Boy in cell A10 instead of cell A8.

=IF(ISERROR(INDEX($A$1:$B$7,SMALL(IF($A$1:$A$7=$A$ 10,ROW($A$1:$A$7)),ROW(1:1)),2)),"",INDEX($A$1:$B$ 7,SMALL(IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1 )),2))

Hope this helps

"TN.Jim" wrote:

I need to be able to pull a list from series of data without sorting or
filtering...
Example:
A B
1 Jim Boy
2 Ann Girl
3 John Boy
4 Mike Boy
5 Tina Girl
6 Matt Boy
7 Beth Girl

Then if a user selects "Boy" in cell A8, I want
A9 = "Jim"
A10 = "John"
A11 = "Mike"
A12 = "Matt"
I can use =index(A1:A7,match(A8,B1:B7,0)) to get "Jim" in A9 but how can I
get
John in A10 etc?

The actual list is much more complicated but I hope that this gives an idea
of what I need to do.

Thanks for the help!

Jim