Forum Discussion
Change value depending on others
Hello everyone,
First time on a forum community, I need help for a little work. Can anyone help me, please?
I have a list of value (section of wood) related to prices for each section. it's like a reference panel, subjected to changes.
I want to create an offer where the price (a cell somewhere, related to a cell included in the reference panel) have to change automatically, according to the reference panel, if I change the section in another cell (also related to the reference panel). How can I do such a thing?
Thanks in advance to those who would try to give me some clues.
(Can I add some print screen? If so, how again?)
Certainly, you can create a dynamic pricing system in Excel by using formulas. If I understand correctly, you have a reference panel with different wood sections and their prices. You want to change the price of a cell automatically when you change the wood section in another cell.
Here's a step-by-step guide on how you can achieve this:
- Create Your Reference Panel: Set up a table with two columns, one for the wood section and the other for the price.
- Name Your Table: Select the data in your reference panel, go to the "Formulas" tab, and click "Define Name." Give it a name, e.g., "WoodPricing."
- Reference Panel: Let's assume your reference panel is in cells A1 to B5, with wood sections in column A and prices in column B.
- Offer Sheet: In your offer sheet, you have a cell (let's say D1) where you select the wood section you want to price. You want to have the price automatically update in another cell (e.g., E1) based on the selection in D1.
- Use VLOOKUP or INDEX/MATCH: In cell E1, you can use a formula to look up the price based on the selected wood section. If you prefer VLOOKUP:
=VLOOKUP(D1, WoodPricing, 2, FALSE)
If you prefer INDEX/MATCH:
=INDEX(WoodPricing, MATCH(D1, WoodPricing[WoodSection], 0), 2)
These formulas will find the price for the selected wood section in the reference panel and display it in cell E1.
Now, when you change the section in cell D1, the price in cell E1 will automatically update based on your reference panel. This provides a dynamic pricing system for your offers.
If you'd like to add print screens, you can describe the content you want to display The text was created with the help of AI.
Additional I recommend always to inform about your Excel version, operating system, storage medium/hard drive, OneDrive, Sharepoint, etc.).
If possible, add a file (without sensitive data) and use this file to describe your project step by step, or add photos with the appropriate description.
In this link you will find some more information about it:
Welcome to your Excel discussion space!
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.
2 Replies
Certainly, you can create a dynamic pricing system in Excel by using formulas. If I understand correctly, you have a reference panel with different wood sections and their prices. You want to change the price of a cell automatically when you change the wood section in another cell.
Here's a step-by-step guide on how you can achieve this:
- Create Your Reference Panel: Set up a table with two columns, one for the wood section and the other for the price.
- Name Your Table: Select the data in your reference panel, go to the "Formulas" tab, and click "Define Name." Give it a name, e.g., "WoodPricing."
- Reference Panel: Let's assume your reference panel is in cells A1 to B5, with wood sections in column A and prices in column B.
- Offer Sheet: In your offer sheet, you have a cell (let's say D1) where you select the wood section you want to price. You want to have the price automatically update in another cell (e.g., E1) based on the selection in D1.
- Use VLOOKUP or INDEX/MATCH: In cell E1, you can use a formula to look up the price based on the selected wood section. If you prefer VLOOKUP:
=VLOOKUP(D1, WoodPricing, 2, FALSE)
If you prefer INDEX/MATCH:
=INDEX(WoodPricing, MATCH(D1, WoodPricing[WoodSection], 0), 2)
These formulas will find the price for the selected wood section in the reference panel and display it in cell E1.
Now, when you change the section in cell D1, the price in cell E1 will automatically update based on your reference panel. This provides a dynamic pricing system for your offers.
If you'd like to add print screens, you can describe the content you want to display The text was created with the help of AI.
Additional I recommend always to inform about your Excel version, operating system, storage medium/hard drive, OneDrive, Sharepoint, etc.).
If possible, add a file (without sensitive data) and use this file to describe your project step by step, or add photos with the appropriate description.
In this link you will find some more information about it:
Welcome to your Excel discussion space!
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.
Waw! That was a fast and complete answer! Thank you very much for that, I will try everything as soon as possible. For information, I use Win11 on a PC and the latest version of Office 365.
Thanks again, maybe contact later for more, if needed.
