VLOOKUP, IF? Question assigning value to text options [Solved]

Soupies - Jan 17, 2018 at 02:23 PM - Latest reply:  Soupies
- Jan 17, 2018 at 04:08 PM

I need to make an spreadsheet that corresponds different text values and gives them a score. I have several tables set up, that I was trying to use VLOOKUP to assign a score to, but I'm not sure what's the best approach.


Column A is one of these text and the corresponding score I want applied (Sally=1, Fred=2)
Column B is one of these (LTC=0, BID=1, TID=3)
Column C I want to be my score

I want it to work like this:
Sally TID 4

I initially thought I had some success with VLOOKUP combined with SUM but alas it was a fluke.

Thank you for any help.
See more 

Your reply

2 replies

Mazzaropi 1829 Posts Monday August 16, 2010Registration dateContributorStatus May 7, 2018 Last seen - Jan 17, 2018 at 03:44 PM
Soupies, Good evening.

This can be one of the ways to solve this question:


With a Table at E1:F11
E1:E11 --> Differents NAMES
F1:F11 --> Related VALUES

I set an example for you:

Please, take a look and tell us if it works as you desire.

I hope it helps.
Belo Horizonte, MG - Brasil.
Marcílio Lobão
Was this answer helpful?  

Thank you for your reply! I will try your approach now and see it if will work, but looks promising. I truly appreciate that you made an example for me.

Respond to Mazzaropi