excel, google app script

Job ID: 34246820

Budget: $2 – $8 USD

I want below formula or google app script
if cell contains (multiple text criteria) then return (corresponding text criteria) in another cell
Related categories: PHP JavaScript Visual Basic Excel Software Architecture