Reference and extract data from another Sheet

[clint182]

Hi all,
So my project is as follows;

In Sheet2 A1:A100 has my team members names and in B1:B100 has the store number that they work at (30 store numbers).

In Sheet1 i want to be able to enter a specific store number in say A2 and it populate a list of team members that work at that store ie: filling cells A5:A20....

I have attached if you wish to review.... I was thinking VLOOKUP but this doesnt seem to be doing the trick

Thanks again

[clint182]

Sorry im new to these forums.....amended as required.

[Haseeb Avarakkan]

Hello, See the attached.

[clint182]

Great advice....thanks