Forum Discussion
FORMULA SOLUTION
Hello there.
I hope everything is going well for you!
If you don’t mind, I would like to you ask a question, and if you have a chance and time to answer it, I will be so happy!
Let me shortly explain the our business and my question for attached excel file.
We are in Kitchen cabinet business since 20 years.
We have many showrooms in NY and NJ state area and working many kitchen cabinet supplier.
All different supplier has different price list, for even the same products.
And each company use unique common code to price it the item.
If I need to give you an example;
B09: Base cabinet – 9” width
NO | KITCHEN CABINETRY | ITEM CODE | PRICE |
1 | PANDA CABINETRY | B09 | $ 110.00 |
2 | SKYVIEW CABINETRY | B09 | $ 120.00 |
3 | JK3 CABINETRY | B09 | $ 130.00 |
4 | LIBERTY CABINETRY | B09 | $ 140.00 |
5 | SJ CABINETRY | B09 | $ 150.00 |
And many more cabinetry company and many more items …
And my target is, our employees save time to give a price quote to customer from different company and also compare the price for each different company for the same product.
If you can find to check the excel file, I believe you can easily understand the logic of the file.
Let’s come to my question,
As you see in excel file, I already can able to compare 5 different company different style of cabinet with playing first and second columns drop menus.
According to cabinetry company choose of user, style list of the company is change too. (Exp: D1 and D2).
But unfortunately according to user choose, price list of the ITEM CODE is not changing like dynamically.
I don’t know it possible or not, or my logic to make something like that is correct or not but I believe there is something like that in excel which I don’t know 😊
If we can do this thing, in one page we can compare many different companies, many different cabinet style and it will be perfect thing for our business !!!
I wish I could explain my question, and I wish you can help me for it 😊
And I will be very happy to answer you if there is any not understandable point in my explanation.
Thank you very very much for your help in advance! And hope to hear something from you.
Please, be safe!
Best Regards,
Ahmet Demir
7 Replies
It's better to have sample file
hi SergeiBaklan
please see in attached sample file.
my request is very simple to explain,
when you changed D1 ( with another Kitchen Cabinet Brand ) D3 will not give an error !!!
thats what i want it ...
its giving an error now because of D1 section is working for only with selected brand price list !
if i can solve this problem, i can compare many brand price list in one excel sheet.
please help me if you have a solution.
thank you for your help in advance!
best,
ahmet
Hello AHMETDEMIR
It is a little difficult to understand how you are using the list of items.
You mentioned drop downs, and you mentioned being able to dynamically see the prices when you choose a product. Without seeing a demonstration or several screenshots, or even a mock-up of what you are trying to accomplish I am only able to make assumptions and solutions based on my assumptions.
If you want to be able to choose a product, then compare products and pricing, a pivot table might help. You could use filters to choose your unique code that would have the 5 different company prices (maybe even a combination of 2 or more filters if you want to add to your quote list to refine the list by grouping/categorizing your products).
If you want to create something like a custom form, you could use a combination of data validation and vlookup on a different worksheet. However, it may not be viable depending on your list and whether you want one drop down with every unique product, or if you want to create groups of different drops down values (perhaps organized/categorized together) to have more manageable sized drop down lists).
Data validation will work like a drop down, then the cell next to it could use that value to do a vlookup to get the price. This would provide a dynamic price that changes when you choose a different value in the drop down.
Hi HCole718 ,
first of all thank you for your explanation,
my request is very simple to explain,
when you changed D1 ( with another Kitchen Cabinet Brand ) D3 will not give an error !!!
that's what i want it ...
its giving an error now because of D1 section is working for only with selected brand price list !
if i can solve this problem, i can compare many brand price list in one excel sheet.
please help me if you have a solution.
thank you for your help in advance!
best,
ahmet
