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.
Hello I think you may be able to help me
I have a staff rota and we use E (early shift) and L (late shift) i want the colobm at the side to add the hours together. So I want to hide the numerical value of those letters up. So for example L=10hours Lx5=50hours? mathetes
I may be able to help, and there are others here on this site who also may be able to help. But in order for anybody to help, you'll need to give a more complete picture (or post a copy of your actual workbook) of what it is that you're working with. And might I suggest that you start a new thread. It isn't really clear that this builds on what preceded it in this thread.
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.
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
