Writing a formula to return a specific value from a table.

Hello community, I'm having trouble making a formula, maybe I'm just over thinking it so I'm here to ask for help! I have a excel document with two sheet tabs: See attached for example. Progr...