returning a list of values meeting a specific criteria

[Guest]

I have a list of data in a worksheet #1 that looks like this after i run some queries

A B
1 Jim
2 Joe
3 Mary
4 Su
5 Frank

In worksheet #2, i want to be able to enter a criteria in a cell (like "X) and have it return all the names that have an X next to them in worksheet #1. something like this

A B
1 X Ji
2 Mar

4 Y Jo
5 Fran

Thanks in advance

 

[Frank Kabel]

Hi
you may try downloadind Alan Beban's array functions
(http://home.pacbell.net/beban)
They'll include a function called VLOOKUPS (for returning multiple
lookup results)

--
Regards
Frank Kabel
Frankfurt, Germany

I have a list of data in a worksheet #1 that looks like this after i run some queries:

A B
1 Jim X
2 Joe Y
3 Mary X
4 Sue
5 Frank Y

In worksheet #2, i want to be able to enter a criteria in a cell

(like "X) and have it return all the names that have an X next to them
in worksheet #1. something like this: