You could use a separate (hidden??) worksheet.

Put the descriptions in column A and the pricing in column B.

Column A ColB
4' stockade fence 28
5' stockade fence 31
6' stockade fence 35

Then give that stuff in column A a nice name.

Now you can use that name as the source for the list in a cell that has
Data|Validation applied (say A1).

Then in B1, you can use this formula:
=if(a1="","",vlookup(a1,sheet2!a:b,2,false))

Debra Dalgleish has lots of notes about Data|Validation:
http://www.contextures.com/xlDataVal01.html

ktyme wrote:

Helllo,
I am trying to create a dropdown menu with individual pricing for each choice.

fence:
4' stockade is $28
5' stockade is $31
6' stockade is $35

I would like each item to be in the dropdown menu and be priced accordingly.

--

Dave Peterson