Formula to look up alphanumeric text and give a value to each Character

I have a table with values for each letter and number. I need to lookup Cell A1 and apply values from the table to each number and letter and sum them up


Example1.xlsx