Sum two cells where one has text with values linked to that text

I'm trying to write a formula that will work out the sum of two cells, where one cell has text (which has a specific number value relating to that text) and the other has the number to multiply by. In the attached file, i have the info all laid out how I want column D to look like with the formula working, along with the values relating to the corresponding text in cells AE/AF

Any help would be greatly appreciated.

Hi, welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )

Try this. (I have a feeling you mean multiply, not sum?)
=IF(C2="","",VLOOKUP(B2,$AE$1:$AF$9,2,0)*C2)

If you really did mean sum, then change to this...
=IF(C2="","",VLOOKUP(B2,$AE$1:$AF$9,2,0)+C2)