I understand the limitations of Xcelsius and am new to Office Online.
The idea here is to create a serial number by store that a vlookup formula
can find.
Column A concatenates C&B
Columna B use an If formula that re-sets the serialization to 1 as the store
number changes B3=IF(D3=D2,1+C2,1)

1 A B C D
2 Concatenate.Serial Store # Employee name
3 101 1 10 Bob
4 102 2 10 Jane
5 103 3 10 Kelly
6 121 1 12 Ted
7 122 2 12 David
8 123 3 12 James
9 124 4 12 Carrie
10 161 1 16 Joe
11 162 2 16 Kristin
12 163 3 16 Al
13 164 4 16 Nick
14 165 5 16 John
15
16 Input Store number 12
17 Concatenate.Serial Employee name
18 121 1 Ted
19 122 2 David
20 123 3 James
21 124 4 Carrie
22 125 5
23 126 6
24 127 7
A18=$D$16&A18 and copied down

Formula
D17=IF(B17COUNTIF(C2:$C$13,$C$15),"",VLOOKUP(A17, $A$2:$D$13,4,FALSE))
The countif determines how many employee's per store.
I hope this helps.
Charlie_Brown


"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!