Translating City Codes to Names (example attached)

I have a large database from a central appraisal district. In the database the city is stored as a numerical value. The problem is I need to convert the numerical value for the city to a text string with the actual city name. For example the values to the attached example database are as follow:
excel help forum 2.xlsx
024 = Hurst
026 = Fort Worth
025 = Euless
017 = Mansfield
013 = Keller

The issue is, I need to convert this column of numbers into the string of the actual city name. Is there some type of command, or macro that I could use to automate this process? Attached is a small example copy of the database.

Thank you

Hi

You can probably use the vlookup-function if you have the list of city-codes stored somewhere.

Your request is very vague and at least for me the attachment isn't much help. Mostly you can use (as perimidt noted) a vlookup function to accomplish this. But your request also seems to indicate you the numerical value to a text string? It might help if you altered your attachment to show what you have and your desired results.

The following in D2 should work:
=VLOOKUP(C2*1,Vlookuptable!A:B,2,FALSE)

Hi

That is because the numbers on the Data-sheet is actually stored as text and the numbers on the vlookuptable-sheet are stored as numbers.
When you multiply a number stored as text it gets converted to a real number.

Try it alone in cell E2, just =c2*1 to see what it gives you.

you don't have the d2*1 in the formula.

You have renamed the sheet from vlookup to VB_lookup without changing the formula.

When I did it, it worked, but got rid of your table reference.