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.
The text cells I'm working with are in the second sheet of the book, the format is text cell followed by the price (example: EQUIPOS and precio USD).
What I want to do is to select the name of an item in the multiple option lists in the first sheet but using the numeric value assigned to each option in my pricing formula.
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.
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.
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.
