1. Use Data Validation to create the drop-down
2. Use something like VLOOKUP() to get the required information once the
selection has been made.
--
Gary''s Student - gsnu200755


"Aitch" wrote:

Hi I am using 2003 version. I have a table with sales information in it and I
am trying to manipluate with the use of a drop down list. What I want to
achive is the following: Use drop down list and depending on what term is
selected will change pricing in the table. How do I link the options in the
drop down box to my specific pricing terms? Many thanks
--
H