Value for text entries from dependant drop down list

[BakerD]

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

[royUK]

It's hard to tell from your description, but probably VLOOKUP could be used.

[JBeaucaire]

From your second example you need to think of the names and the "values" separately. They need to be side by side in adjacent cells in a table that can be matched.

Please Login or Register  to view this content.

Now a VLOOKUP formula will work against that data. You know, it seems like more work than is needed to keep the lists in separate columns. If you put all the "items" in one set of columns then the same formula works whether the item is a fruit or a veggie.

Please Login or Register  to view this content.