Hi BigPig,

For some reason, I am not having much success. Is there anyway you can send
me an example spreadsheet?

"BigPig" wrote:

Hi Misty,

If the end result for your question is for a cell to display 3.50 after
selecting 'Bamboo', then why not place these lists in your worksheet/book
somewhere. For example:
Column A - Bamboo, Maple, Oak
Column B - 3.50, 2.50, 1.25

if your drop down is in cell a5, then in cell b5 you could type:
=INDEX(A1:B3,MATCH(A5,A1:A3,0),2)

Hope that answers your question.

"Misty" wrote:

I have 2 drop down lists made, but I want to have one linked to the other
one. For example the first list has types of wood in it.
Bamboo
Maple
Oak

The 2nd one has pricing in it.
1.25
2.50
3.50

If I click on Bamboo - I want the 2nd list to auto generate 3.50. Can that
be done?