Return Excel List with multiple drop down lists

Randallh

New Member
Joined
Nov 26, 2008
Messages
38
I hope I can explain this well enough. I have a table that is columns A-P and with duplicate and unique values. The Data I want to match is in column I and column P. One is a name and the other is a date that has been extracted to month and year. I have one drop down list that has names and another that has month and another that has year. I want to return multiple different columns to create a variable list that is based on the points chosen from the drop down lists that will show the data from the table with all data that matches the name and month/year combo. The table is constantly growing and will continue to have multiple months in it for years to come as they get added. Below is a simplified version of my excel.

Data

<tbody>
</tbody>
ABCDE
Report #1Cost #1Name #1Project #1Date #1
Report #2Cost #2Name #1Project #2Date #1
Report #3Cost #3Name #2Project #3Date #1
Report #4Cost #4Name #1Project #4Date #2
Report #5Cost #5Name #2Project #5Date #2
Report #6Cost #6Name #1Project #6Date #2
Report #7Cost #7Name #2Project #7Date #1

<tbody>
</tbody>
Drop down lists
NameList of Names
MonthList of months
YearList of years

<tbody>
</tbody>

List of data will return below drop down lists.




I know I can use index formulas, but I just can't seem to figure it out after searching for the answer. If there are other ideas, then I am more than open to them. I have done some VBA coding as well, but I would like to stay away from coding if possible so everybody else that uses this sheet doesn't have to deal with macros.

Thanks.
 

Rijnsent

Well-known Member
Joined
Oct 17, 2005
Messages
1,170
Office Version
365
Platform
Windows
Hi Randallh,
if the whole purpose is to basically output a filtered list, why not make your data into a Table (Excel menu: insert->table), selecting that table and inserting a couple of Slicers (instead of your dropdowns). For the slicer: select the table and add one in the menu Design (for table). That's rather user friendly, e.g. allows for multiple selections.
Hope that helps you,
Koen
 

Randallh

New Member
Joined
Nov 26, 2008
Messages
38
Hi Randallh,
if the whole purpose is to basically output a filtered list, why not make your data into a Table (Excel menu: insert->table), selecting that table and inserting a couple of Slicers (instead of your dropdowns). For the slicer: select the table and add one in the menu Design (for table). That's rather user friendly, e.g. allows for multiple selections.
Hope that helps you,
Koen
That works for some of the data, however, there is other data that I would like to capture using calculations between different columns so I can analyze the data a bit more heavily than just filtering and showing the list. Any additional thoughts on help with this? I did try the slicer and it works great for the simplistic filtering and doing it quick which I like and will probably use for the users, but I have my own analytics that not everybody will see so it can be more complex if need be.
 

Forum statistics

Threads
1,085,652
Messages
5,384,950
Members
401,927
Latest member
commae

Some videos you may like

This Week's Hot Topics

Top