Fill Column with values from a row with a specific text on the left

Hello   I have a large dataframe and I want to create a new column with gives me the value of cell on the right side of a cell that contains a specific text.   The table below is an example of my...