Forum Discussion
Looking for a function for choosing from a list then that lists selects a column and updates target
Hi Folks,
Need Help!!!
How do I use a list that determines the overall pricing selection in another column that is connected to a description.
My columns as follows in sequence:
Model: SKU: Description: Qty: Unit Price: Total Price
E.G.
Each tier has a certain discount level with multiple rows of products connected to the unit price.
When I choose a Tier, that tiers price should be in the Unit Price column should update with that tiers discount price.
When I select a product from a data validation list in a description I want the right product price should appear in the Unit Price column.
HELP!!
- mathetesSilver Contributor
Your description is a bit confusing. I'm attaching a file that demonstrates how to create what I call a Cascading Data Validation (also known as "drop down").
If this is not in line with what you're looking for, please come back and, if possible,
- post a copy of your actual file (or a good facsimile of it) on OneDrive or GoogleDrive, with a link pasted here that grants access
- see if you can create a clearer description of the task