Neil, see if this will help,

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

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Neil M" wrote in message
...
Okay, first here is what I have. I will use examples to be as detailed as
possible.

On my worksheet I have a column (Lets say A1). In that column there is a
drop down menu/list of different types of materials. I have created this
drop
down from a range of cells using the data/validation/list tool.

Now, in this menu, I have different types of lumber (i.e. 2 x 4, 2 x 6, 2
x
8, etc.) next to that cell (lets say A2) I need a formula that will
automatically select a wieght of the type of lumber I choose. For example,
a
2 x 4 weighs 2.25 lbs per foot. So, if I scroll to "2 x 4" in cell A1, I
want
cell A2 to automatically display "2.25".

Is this possible?

Thanks