Dear All,
I have the following table, with multiple products and different prices ranges by quantity/volume:
Excel 1.PNG
On another table, I have a drop down list with a product name, quantity and price:
Excel 2.PNG
Question:
1) How can I get automatic price on cell C13, based on product selection and quantity range for the product selected?
I've also added a sample workbook with the above data.
Any help I would appreciate.
Thank,
Murilo
Last edited by murilo.costa; 05-28-2018 at 10:23 AM. Reason: Adding a sample workbook
Looks like you have merged range in column A. Do away with it and populate Product name for each line. It will make further analysis/data manipulation much easier.
Also, I'd recommend uploading sample workbook using "Go Advanced" found at bottom right of Quick Reply/Edit menu. And then locate "Manage Attachments" hyperlink and click on it.
This will launch new tab/window with file management menu.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Thank you for your suggestion!
I've attached a sample workbook! Could you help me with that?
Thank you for your suggestion!Originally Posted by CK76
I've attached a sample workbook! Could you help me with that?
Try something like attached.
Thank you! Perfect! It worked!
You are welcome and thanks for the rep
If this solved your question, please mark the thread as solved by using Thread tool found at top of your initial post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks