Lilfiger19
New Member
- Joined
- Feb 8, 2014
- Messages
- 7
Hi Guys!
Can anyone tell me how to do the following?
I have a workbook with two sheets. The first sheet (Detail) provides all of the data and the second sheet (Lookup) houses a data validation list. I want to be able to return all matches based off of an associate name, once chosen from the drop-down list.
If I choose Employee A (Detail!$D3), and that employee has several records on the detail tab, I want it to automatically return all of those records below the drop down box. I have tried using MATCH, INDEX & VLOOKUP to no avail.
Lookup Sheet:
<tbody>
</tbody><colgroup><col><col><col span="5"></colgroup>
Detail Sheet
<tbody>
</tbody><colgroup><col><col><col><col><col></colgroup>
Can anyone tell me how to do the following?
I have a workbook with two sheets. The first sheet (Detail) provides all of the data and the second sheet (Lookup) houses a data validation list. I want to be able to return all matches based off of an associate name, once chosen from the drop-down list.
If I choose Employee A (Detail!$D3), and that employee has several records on the detail tab, I want it to automatically return all of those records below the drop down box. I have tried using MATCH, INDEX & VLOOKUP to no avail.
Lookup Sheet:
Associate Name: | Joe Smith | |||||
Name | EE ID | Status | Account Name | Account number | ||
Rec 1 | ||||||
Rec 2 | ||||||
Rec 3 | ||||||
Rec 4 | ||||||
Rec 5 |
<tbody>
</tbody><colgroup><col><col><col span="5"></colgroup>
Detail Sheet
Name | EE ID | Status | Account Name | Account number |
Joe Smith | Q062230 | Other | RIVERSIDE SENIOR LI | 20802252 |
Joe Smith | Q052230 | Other | DAYS INN-ATHENS #06 | 40804593 |
Jessica English | F652230 | Full Commission | MEALS ON WHEELS | 40798878 |
Todd Williams | F652230 | Full Commission | CSL-WESTMINSTER ALF | 70942586 |
<tbody>
</tbody><colgroup><col><col><col><col><col></colgroup>
Last edited: