How to Extract A Number from String if Text within the String Equals XYZ

Hi.
Although the table was complex but I tried. The formula mostly puts the numbers but it has few exceptions.
1. Column name have to be same as in the text string otherwise it will not able to find.
2.nd. Some column names includes two separate words. In that case we have problem too. You may bring them together with "_" sign.

To make the formula work properly then you should include a words which is in the column to the text string and they have to match by 100 percent.
Have a look to the file. Check them out and you will see unadecuacies.