Data validation..the next step...more than one column

S

shaun collier

Hi all,
Mastered the very basic data validation even using names!!. However I now
wish to use my product sales data worksheet which has 2 columns, how do/ is
it possible to have a drop down list as in data validation but for columns,
i.e., choose product 'a' and product 'a's sales price is also chosen
automatically.
Regards
Shaun
 
B

Bob Greenblatt

Hi all,
Mastered the very basic data validation even using names!!. However I now
wish to use my product sales data worksheet which has 2 columns, how do/ is
it possible to have a drop down list as in data validation but for columns,
i.e., choose product 'a' and product 'a's sales price is also chosen
automatically.
Regards
Shaun
Click to expand...
Sure it is possible, but you'll need a formula in the cell to contain the
price. Look in help for VLOOKUP. It should explain how to do this. If you
need more help, ask.
 
Top