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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation List (conditional) 2
vba to copy data from sale receipt to next available column in aninventory worksheet 0
Data Validation 1
Data Validation 1
Copy and shift data automaticaly 0
Data validation lists 1
vba to copy data from sale receipt to next available column in an inventory worksheet 0
VBA to run all variable combinations in a calculation model and store result 6

Top