Forum Discussion
Solved
Use calculation formula based on a drop down list cell
Is it possible to use a different calculation formula in a single cell, based on another cells data on a table?
I want ‘column 1’ to be a drop down list and based on what that option is give a different formula in the ‘weight’ cell?
I want ‘column 1’ to be a drop down list and based on what that option is give a different formula in the ‘weight’ cell?
I put your question to the Bing chatbot:
To change the range of an Excel table, you can use the Resize command. Here’s how:
- Click anywhere in the table, and the Table Tools option will appear.
- Click Design > Resize Table.
- Select the entire range of cells you want your table to include, starting with the upper-leftmost cell1.
You can also convert a table to a range by clicking anywhere in the table and then going to Table Tools > Design on the Ribbon. In the Tools group, click Convert to Range2. Is there anything else you would like to know? 😊
4 Replies
Matthewprice Yes - you can use MATCH and CHOOSE. So make a list of the dropdown options somewhere, and do: =CHOOSE(MATCH(dropdown, list of options, 0), 1st formula, 2nd formula, ...)
Savia Firstly thank you so much, I appreciate this like you would not believe. I am having trouble, I have never used wither Match oo choose, could you tell me where I have gone wrong. I am just getting #Name Thank you
Matthewprice I think the problem is coming because you haven't defined the terms used in your MATCH. Really the list should be in separate cells - see example attached.
