Okay. So.

I have this worksheet that has a bunch of data validation drop-down lists.
Each list has a certain type of computer part in it, so the first list is a
bunch of cases, the second list is a bunch of motherboards, and so on. Each
list has about three or four different makes, brands, models, etc, of that
part.

To the side, there's a couple columns, Price, S&H, Notes, Link, Number of
Reviews, and % of Reviews that are 5-Star. So, right now as it stands, I'm
using VLOOKUP so that when you select an item in the list, all of the data to
the right changes accordingly, referring to data on a different spreadsheet
called Database.

What I want to do right now is enable a list of preset configurations. So
at the top of the list of parts, there would be a drop-down menu with items
such as "Budget," "Mid," and "High-End," referring to the different computer
builds. I want it so when the user selects from the list, the rest of the
parts change accordingly. So if they clicked Budget, every computer part's
drop-down list would go to the cheapest item as determined by the price.

Really hard to explain with images...which I could make, upload, and link to
if that's okay.

As it stands, the Configuration list is in cell C7. The Case drop-down list
is C11, Motherboard C13, CPU C15, and so on. The price for the currently
selected Case is F11, Motherboard F13, CPU F15.

If there's not a way for Excel to determine which item on the list has the
lowest price, is there a way to make it so that I specify which items are
selected when the user selects Budget from the Configuration list?

Thanks a ton, I know my question is confusing!