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
Bookmarks