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:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Person
[/TD]
[TD]Date
[/TD]
[TD]Item Purchased
[/TD]
[/TR]
[TR]
[TD]Person X[/TD]
[TD]01/01/2014[/TD]
[TD]Apple[/TD]
[/TR]
[TR]
[TD]Person Y[/TD]
[TD]01/01/2014[/TD]
[TD]Orange[/TD]
[/TR]
[TR]
[TD]Person X[/TD]
[TD]02/02/2014[/TD]
[TD]Grapes[/TD]
[/TR]
[TR]
[TD]Person X[/TD]
[TD]03/03/2014[/TD]
[TD]Pear[/TD]
[/TR]
[TR]
[TD]Person Y[/TD]
[TD]03/03/2014[/TD]
[TD]Banana[/TD]
[/TR]
</tbody>[/TABLE]

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.