Hi,

Not sure if this is the right section for this query, but I hope someone can help.

I am trying to assign values for texts from dependant drop down lists, and muliply that by another cell ref.

List A List B Quantity Cost
Fruit Apple 4 200
Vegetable Carrot 3 60
Fruit Pear 5 180


Corresponding lists

Fruit List Vegetable List
Apple = 50 Carrot = 20
Pear = 30 Sprout = 12


So I am using data validation for the lists, the lists are contained in the same worksheet.

I have thought about using an =if( , , ) command, but due to the large number of choices contained in the lists, I was hoping there is a smarter way of working this?

Please help...

Cheers,
Dave