Hi!

Try this:

Entered in A9 as an array using the key combo of CTRL,SHIFT,ENTER:

=IF(ROWS($1:1)<=COUNTIF(B$1:B$7,A$8),INDEX(A$1:A$7 ,SMALL(IF(B$1:B$7=A$8,(ROW(A$1:A$7)-ROW(A$1)+1)),ROW(A1))),"")

Copy down until you get blank cells.

Biff

"TN.Jim" wrote in message
...
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