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