wanting to add numerical value depended on a alpha code

i am trying to add a numerical figure in a cell but it will vary depending on what text is added to another cell.

my question is, how if at all can this be done?

Thanks in advance