Assign table value to letters in a string and sum them up.

[Jurek]

I have not found anything on the forum or anywhere, maybe this is not possible.

I would like to assign numerical values (from an additional table) to each letter in a string (let's say in E2) and sum them up in F2. Is that at all possible?



for example:

string in E2: AGTCV

values in another table: A=1,G=2,T=5,C=1,V=4

output in F2: 13

[martindwilson]

try it like this

[Jurek]

That works, thanks a ton!

[bebo021999]

Assuming reference table in A1:B26, in which A1:A26 is alphabet list, B1:B26 is assigned value.
E2 contains text
In F2:

Please Login or Register  to view this content.

Confirmed with Ctrl-Shift-Enter