Hello all,

This is my first post here and I'm hoping somebody can help me out:

I'm trying to create a spreadsheet that allows me to have multiple dropdown boxes (ie. color, make, Type) and within each dropdown box have different options (ie. red, blue, yellow; Toyota, Honda, Lexus; SUV, sedan) and based on those inputs have a separate cell perform a calculation using input from a standard table of values (ie. Cost). For this example, if I were to choose Red, Toyota, SUV, I would receive a calculation back on the car's value. I tried using a large data table with the different headers and multiple if statements, but that didn't work out very well...

Any help/tips would be greatly appreciated!

Thanks!