Excel replace multiple text options within one cell with other text

How can I replace one set of text options with another? I was thinking that an Index/Match combination might work, but I cant figure it out. Perhaps a VLookup function?

For example:

My report output looks like this.

Not Applicable (appointment offered)

No Contact

Not Applicable (appointment offered)

Not Applicable (appointment offered)

And I need to create a column next to it that matches the following:

01 = No Contact

02 = Declined Services

03 = Currently Enrolled

04 = Not Applicable (appointment offered)

05 = Other"

Here is a different example.

Report Output looks like this:

Clinic-South

Clinic-3rd St

Clinic-Columbus

And I need to replace with the following:

3rd St.--> 076465

South--> 613797

9th St.--> 878652

Columbus location should retu as an error.

Recent Questions...