I am working on an estimation worksheet. I would like to use a series of drop downs to select the variables that lead you to the final selection then have another cell pull the cost based on all those values.

Example

First list is for Color
Second list is for size
Third list is for type
Fourth list is for texture

So based on these four drop down list I need to assign a cost.

Salesperson Tom is writing an estimate and selects from the drop down menus

Red (color) 26x48 (size) Nema 1 (type) Smooth (Texture)

One sheet in the workbook has all the prices based on this list of options. I would like to pull the correct cost based on the selections used.

Presently my drop downs are using defined names so that I can keep the lists off of the main sheet and away from accidental mess ups.

I think I am already starting in the wrong direction by using data validation and that I should probably be using VBA to define the list but I am a novice, not a newbie but not the programmer that a lot of you on this list are.

So if anyone can help me through the conceptual part of this and guide me to the best way to set this up and then work on the code I would appreciate it.

Thanks a million for all the help I have gotten here in the last year.

Linc