Saw this link posted in this group a few days ago. Very good stuff.

http://www.contextures.com/xlDataVal02.html

"Armando" wrote:

I have created a spread sheet in which has standard pricing for standard
products. Each row has a drop tab cell in which lists standard sizes. How do
I make a cell link according to what is selected in the "Validation List
box". It needs to work so that if I select a 18" box from the drop down tab
the cell under "Price" changes to that size. I know it sounds confusing, I
can clarify if needed!!!!