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

Report
-
 Soupies -
Hello,

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.

Ex:

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:
A B C
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.

1 reply

Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
135
Soupies, Good evening.

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

=SUMPRODUCT((($E$1:$E$11=A1)+($E$1:$E$11=B1))*($F$1:$F$11))

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

I set an example for you:
https://www.sendspace.com/file/x540nt

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
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 3809 users have said thank you to us this month

Mazzaropi,

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.

Soupies