Solved

# Populate data into a sheet - using data valuation selection

Posted on 2016-08-16
40 Views
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
0
Question by:route217
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 2

LVL 31

Accepted Solution

Subodh Tiwari (Neeraj) earned 500 total points
ID: 41758956
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))),"")
``````
And copy down until you get blank cells.

For details, refer to the attached.
Test-123.xlsx
1

Author Comment

ID: 41758973
Many thanks for the excellent feedback let me check.
0

Author Comment

ID: 41759445
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

### Suggested Solutions

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
###### Suggested Courses
Course of the Month4 days, 22 hours left to enroll