Setup a product-price table.

See this:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"chrisbmo2000" wrote in message
...
I have excel 2003 and I am trying to link prices with products using the
list
validation. is this possible or do I need to go in a whole other
direction?
thanks in advance
chris