Duke,

Thank you for your input....unfortunately, because of some limitations of
Crystal Xcelsius (the application this excel spreadsheet "feeds") I have to
limit my data manipulation to formulas I can embed in the actual file;
Vlookup and Hlookup formulas are generally very helpful, but the data I need
to manipulate for this application is throwing me a curve ball....

"Duke Carey" wrote:

Treat your data as a database, then on the sheet where you want the filtered
data to appear, go to Data-Import External Data-New Database Query

If you walk through the steps there, you'll see how you can identify the
Excel file as the database, and the range of data as a table. Use the help
file in Query to learn how to create a parameter query linked to a cell, and
plan for that cell to hold a store number. Once you've created your query
and identified the cell, you can change the cell value and run the query.
It'll bring in all the pertinent data



"David B" wrote:

I need to create a lookup formula that will find all employees for a given
store location. My data is organized as follows:

Store # Employee name
10 Bob
10 Jane
10 Kelly
12 Ted
12 David
12 James
12 Carrie
16 Joe
16 Kristin
16 Al
16 Nick
16 John

The obstacle I've encountered with a VLookup is that if I look for Store
#12, my formula only returns the first employee for store #12. I need to
create a formula that will extract all the employees, then create a new table
with that data.

Help!