lookup to array in one cell

 hi, i have a array in one cell, like this: dog,cat,fish   and i have a table of prices, like this: dog - 1 cat - 2 fish -3   i want to get a formula that sum all the array, 1+2+3=6.   i c...