SOLVED

Use calculation formula based on a drop down list cell

Copper Contributor
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?
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_0-1584656755539.png

 

best response confirmed by Hans Vogelaar (MVP)
Solution

@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.

@Savia Thank you. I was able to use your solution to create a formula that fit my need exactly.

1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

@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.

View solution in original post