Forum Discussion
Assign numeric value to text cell
Hello, I'm making a pricing spreadhseet and I need to assign a numeric value to a text a cell which can be selected from a multiple option list that lies in another sheet in the same document. Th...
I've added one enhancement to the solution JMB17 provided: I converted the list of places into a Table, so that it's possible to add new names and values to it, and those automatically cascade to the rest of the spreadsheet. That's done with the assumption that you might want to add further variables in the future; if that will never happen, it's unnecessary.
The same could be done to the other tables.