Extract values from a column

Once again, thanks Quong! It works!

Just that I was hoping to only extract the Nominal and tolerance information for PG and TPG M.I type items. As for the rest of the M.I type items (e.g CMM, SRT), I am hoping to extract their respective full name, which I had indicated in Column Q to X. (E.g for M.I type CMM under Column F114, I am hoping to extract "CMM" from Column R15, and for M.I type SRT under Column F115, I am hoping to extract "Surface Roughness Test" from Column X11 etc)000

I have attached my workbook for your reference. I have also highlighted those I need to extract in yellow.

Let me know if you have any doubts or need further clarification, and I would be most glad to assist.