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

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

Hi Aitch

By using data validation you will be able to use an IF statement in the
validation menu.

When you select Data Validation, choose the list option and then in the
selection field below, type in your IF statement. You can have up to 8 NEsted
IF's in one statement and you must create named ranges for the other options.

S

"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