Assigning numerical value to different words to be used in a formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1991390%22%20slang%3D%22en-US%22%3EAssigning%20numerical%20value%20to%20different%20words%20to%20be%20used%20in%20a%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1991390%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20everyone!%3C%2FP%3E%3CP%3EI%20have%20a%20table%20that%20I'm%20trying%20to%20make%20where%20I%20assign%20numerical%20values%20to%20a%20few%20different%20items%20-%20I'd%20like%20to%20make%20it%20easy%20for%20someone%20working%20with%20me%20to%20assign%20photo%20sessions%20so%20that%20it's%20fair%20for%20all%20the%20photographers%2C%20without%20them%20burning%20half%20they%20grey%20matter%20every%20time%20they%20have%20to%20try%20and%20balance%20it.%3C%2FP%3E%3CP%3EThe%20idea%20is%20that%20%22Sold%22%20or%20%22Not%20Sold%22%20would%20be%20equal%20to%201%20or%200%20(self-explanatory)%2C%20where%20the%20clients%20are%20staying%20is%20either%202%20or%203%20value-wise%2C%20and%20how%20many%20people%20are%20in%20the%20group%20is%20either%201%2C%202%2C%203%2C%20or%204%2C%20based%20on%20how%20much%20they%20would%20spend%20on%20average%20-%20Individual%2C%20Couple%2C%20Family%2C%20Group%2C%20respectively.%20I%20started%20it%2C%20but%20I'm%20really%20confused...%20I%20tried%20to%20use%20a%20combination%20of%20COUNTIF%20and%20VLOOKUP%2C%20but%20I%20wasn't%20able%20to%20get%20the%20correct%20result.%20Basically%2C%20I%20would%20need%20the%20%22Value%22%20to%20be%20equal%20to%20%22Sold%2FNot%20Sold%22*%22Place%22*%22People%22%2C%20where%20all%20of%20those%20have%20the%20assigned%20value.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20appreciate%20it%20if%20you%20had%20any%20pointers...%20Thank%20you%2C%20even%20for%20just%20reading%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1991390%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1992342%22%20slang%3D%22en-US%22%3ERe%3A%20Assigning%20numerical%20value%20to%20different%20words%20to%20be%20used%20in%20a%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1992342%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F903122%22%20target%3D%22_blank%22%3E%40AndreiMihalache%3C%2FA%3E%26nbsp%3BPerhaps%20like%20in%20the%20attached%20file%3F%20I've%20added%20some%20named%20ranges%20to%20keep%20the%20formula%20easier%20to%20read%20and%20maintain.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi, everyone!

I have a table that I'm trying to make where I assign numerical values 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, 3, or 4, 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.

1 Reply

@AndreiMihalache Perhaps like in the attached file? I've added some named ranges to keep the formula easier to read and maintain.