List Selection Logic

I've put together a list of groceries my wife and I commonly buy along with the store we buy them from and the price of the item (i.e. Yogurt, Target, $0.30). On a sperate excel sheet I've created a drop down list of all the grocery items and my ultimate goal is to make it work so that when I select an item from the list, excel looks at which store sells the item for the smallest value and displays that store and price of the item in the cells next to the item from the drop down menu:

Sheet 1:
|Apples|Store 1|$1.27|
|Apples|Store 2|$1.03|

Sheet 2:
|Apples|Store 2|$1.03|
^^^^^ Selected from the drop down menu

The problem I run into is that one, I can't figure out how to assign multiple values (prices) to the same text tag (i.e. apples) and make excel recognize the difference. If I name the apples two seperate names like "Apples 1" and "Apples 2" then it defeats the purpose of it all. and two, unless for every drop down block I include in a row I have to, in the cell next to it, type =if functions for every grocery item and there's just gotta be an easier way to do this.

My ultimate goal is to just make a system of logic so when I tell Excel to look at "Apples" it finds the store with the cheapest apples and tells me what the store is and how much they sell for. Any help on this would be freakin' awesome.

Thanks in advance.

PL see attached file.