Match and replace with index

Hi,

This program is working really nice. Please let me know, what should I do to achieve the following:
Currently we are replacing the City Name with number. Now I need to extend this little bit. In the sheet2 i.e. "City". In the first column there is the list of the city. Now I have added column B with some text in front of each city.
When I will run the function in sheet1. I want to replace the city name in sheet1, with the corresponding text in the column B in front of that city.
e.g. In sheet2 i.e. "City":
Sr. No. Column A Column B
1 Auckland City of Sails

Now in sheet1 stead of replacing "Auckland" with 1, it will replace it with text "City of Sails".
Please help me to do this. Thanks.