Dynamic Drop-Down Lists That Shorten Once Items Are Selected

I created an Excel workbook with some help from the group. I can't post it because it has proprietary info. so I posted a simple sample instead.

Basically, there are three separate sheets containing multi column vertical lists with model, description, price, etc. In each column the items are divided into categories. I use data validation to create a list in one cell, and VLOOKUP in an adjacent cell to pull up cost, so I can do calculations on the data. In the attached sample, I have engines for various brands of cars, in several value categories, and different sizes. These categories all appear in the vertical list. Since the actual sheets contain a lot more choices what I'd like to do is have say, three pull downs:

Make::Category::Size

In this way, the pull down lists are shorter, and the price is obtained after narrowing down the choices. I feel like Excel should be able to do this. I've looked at Access, but the learning curve is a little intimidating.Also, after creating the calculator, how do allow the menus to be selected to pull down the choices, without the possibility of the user erasing or changing cells or data, and can I make the cells default tro a click her to choose message, or make the cell look like a button before the choice. Any ideas? Thanks for your help!

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you are new, I shall attempt to do it for you this time.)

Please look at the splash screen when you launch Excel and make a note of the version, then update your forum profile. Thanks.

Please see post #3 and update your profile.

Good thread titles are a requirement here: all you have to do is ask yourself what you are trying to do, and your title is in the answer.

Create a desensitised version to share.