Populating a list by selecting data in another list.

[DrunknMunky14]

I figure this is an unusual question, and I'm just hoping their is an answer out there.

I am currently accessing data off a SharePoint server where the data will self populate into my excel document. This works fine.

I have a drop-down list created through data validation. The drop-down list is of people. I have made this so the values don't duplicate.
Each person has purchased a number of items on different days. There are no duplicating values of people and dates. So person x has purchased on date y and date z (not twice on y and z).
I was wondering if there was a way to populate a second drop down to choose if I wanted to access data on date y and not date z when I select person x.

I'm try to avoid having a column of grouped people and date in a single cell because the list would be too long.

To give a better idea of the data:

Person	Date	Item Purchased
Person X	01/01/2014	Apple
Person Y	01/01/2014	Orange
Person X	02/02/2014	Grapes
Person X	03/03/2014	Pear
Person Y	03/03/2014	Banana

<tbody>
</tbody>

So my drop-down has two options: Person X and Person Y.

The second drop-down:
If Person X is selected will have: Apples, Grapes, Pears.
If Person Y is selected will have: Orange, Banana.

Any help will be amazing. I also have access to the last 3 office excel versions if I need to go back to Excel 2007 or something.

 

[pareshj]

Hi DrunknMunky14,

You need to create multiple dependent drop list in excel.
You can check this link, how to create the same :

Create Dependent Drop-down lists in excel | S&P Infotech Blog


Hope this helps you.

 

[DrunknMunky14]

EDIT ON ORIGINAL POST!!!!

The second drop-down:
If Person X is selected will have: Apples, Grapes, Pears.
If Person Y is selected will have: Orange, Banana.

This is wrong, I was suppose to say:
The second drop-down:
If Person X is selected will have: 01/01/2014, 02/02/2014, 03/03/2014.
If Person Y is selected will have: 01/01/2014, 03/03/2014.

Then I'd use VLOOKUP to find Apple if "Person X" and "01/01/2014" are selected.


Also, Pareshj,
Thanks for the quick response.
Sadly, I don't know how well that will work with my data.
I will be getting new additions to the database daily, so I can't have a list of pre-set unchanging values like that.