You can use the VLOOKUP function to return related prices. There are
instructions he
http://www.contextures.com/xlFunctions02.html
There's a sample order form here were prices are returned for the
selected item:
http://www.contextures.com/xlOrderForm01.html
Josh wrote:
How do I select a item in a drop down or Validation and get a price to show
up in another cell. I have 30 items in my drop down. So in column C it will
need to reference 30 prices along with those items. I think you can only
have 7 If then sceriario's. This is excell 2003
--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog:
http://blog.contextures.com