Mar 19 2020 01:27 PM
Mar 19 2020 02:43 PM
@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, ...)
Mar 19 2020 03:27 PM
@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
Mar 20 2020 02:25 AM
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.
Jan 23 2023 09:38 AM
@Savia Thank you. I was able to use your solution to create a formula that fit my need exactly.
Mar 20 2020 02:25 AM
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.