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:
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.
VLOOKUP, IF? Question assigning value to text options