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

Question

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.

Mazzaropi · Answer

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

VLOOKUP, IF? Question assigning value to text options

1 response

Similar discussions

Subscribe To Our Newsletter!