Convert numbers in a column to words in another

Hello,

I have a report for staff at my company and for their titles (ie. Mr, Mrs etc) it has used the code of the HR system rather than the word. This means that anyone who is a Mr has the number 1, Mrs is a 2 and so on.

Is there a formula I can use that will change all the 1's, 2's, 3's in one column to Mr, Mrs, Ms in the next?

Thanks for the help.

You can probably one of 2 methods:
1. IFS formula - ifs(b2=1,"Mr",b2=2,"Mrs",b2=3,"Dr",b2=4,"Miss"),etc...
2. Create a table listing the numbers and then what they mean, then use either Index/match or vlookup against the table.