Forum Discussion
Assign numeric value to text cell
If I understand what you're asking, it's VLOOKUP that you need. I've started it for you in the first three items on your list, with the assumption that you can follow the example and finish the rest. Feel free to come back with questions if you still have them.
mathetes I'm still messing around with it, if I crack it, I'll update... Thank you very much.
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.
Keep messing around. I just saw this and am busy the rest of the evening. Will not be able to look at it until tomorrow morning.
