Forum Discussion
marturzyca
Jan 24, 2024Copper Contributor
Can I use a formula based on a text from a drop down list in a different cell?
Hi, I have created an invoice template with a drop down list for chargeable items. I would like to have a formula which would calculate the value based on the drop down selection. I have tried to use...
marturzyca
Jan 24, 2024Copper Contributor
I think I've fixed it, tried =CHOOSE(MATCH(... again and it's working. I must have had an error in the formula earlier.