Any Excel gurus

[roro]

Appreciate any help with following excel formula query
If one cell contains a given text, then how do I take a $ value from a second cell and insert that $ value in third cell

 

[hogjowl]

Appreciate any help with following excel formula query
If one cell contains a given text, then how do I take a $ value from a second cell and insert that $ value in third cell

My son-in-law is a somewhat amateur guru at it. He can whip up a spread sheet that works wonderfully for about a week.