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 that's brilliant... would you mind if I asked you a similar question?
I have a table that I'm trying to make where I assign an arbitrary value to a few different items - I'd like to make it easy for someone working with me to assign photo sessions so that it's fair for all the photographers, without them burning half they grey matter every time they have to try and balance it.
The idea is that "Sold" or "Not Sold" would be equal to 1 or 0 (self-explanatory), where the clients are staying is either 2 or 3 value-wise, and how many people are in the group is either 1, 2, 4, or 5, based on how much they would spend on average - Individual, Couple, Family, Group, respectively. I started it, but I'm really confused... I tried to use a combination of COUNTIF and VLOOKUP, but I wasn't able to get the correct result. Basically, I would need the "Value" to be equal to "Sold/Not Sold"*"Place"*"People", where all of those have the assigned value. I would appreciate it if you had any pointers... Thank you, even for just reading this.
Did you ever get help with this in having the same issue
