Hai,

I have came across to some interesting question by a management. The question is can we add letter as numbers. Meaning each letter assigned a number and it should add or sum the numbers.

I have letter A-Z in column A and number assigned to each letter in Column B.

So if user type any word or words then it should sum the numbers and give me the total.

For Example:

Example 1
C = E
E = 5
L = 12
X = 24

So the word is Excel which is equal to 5+24+3+5+12 = total 39
Example 2
W = 23
o = 15
r = 18
l = 12
d = 4

So the word is Excel which is equal to 23+15+18+12+4 = total 72
Appreciate if some1 can help me to get formula or VBA function as my data is huge with 700K - 900K rows