Populate data into a sheet - using data valuation selection

Hi Experts using Excel 2013

Not sure how to do this but need a formula or macro (better if this can be done by formula) to do the following:

Sheet Master

Cell B1 Whatever the user selects here based on the data in the data sheet I want to populate the employee names from the data sheet into sheet Master cell A3 onwards.

So if I select Apple pull back all the apple employee name from the data sheet and likewise if I select Dell in Cell B1 sheet Master populate the employee names for the Dell workers.
Test-123.xlsx
route217Asked:
Who is Participating?
 
Subodh Tiwari (Neeraj)Connect With a Mentor Excel & VBA ExpertCommented:
On Master Sheet, in A3, try this Array Formula which requires confirmation with Ctrl+Shift+Enter instead of Enter alone.

In A3
=IFERROR(INDEX(Data!$B$2:$B$20,SMALL(IF(Data!$A$2:$A$20=$B$1,ROW(Data!$A$2:$A$20)-ROW(Data!$A$2)+1),ROWS(A$3:A3))),"")

Open in new window

And copy down until you get blank cells.

For details, refer to the attached.
Test-123.xlsx
1
 
route217Author Commented:
Many thanks for the excellent feedback let me check.
0
 
route217Author Commented:
0
All Courses

From novice to tech pro — start learning today.