Replacing Multiple Cells with Formula

[rc_schawel]

i am migrating a client's products from one e-commerce platform to another. currently cleaning up the product data through excel. i now have a list of products which are matched with a numeric ID created by the previous platform. i need to replace those numeric IDs with text however cannot spend the time to replace them individually. is there some sort of formula that can automate the whole process?

example:
KEY
1 = chicken
2 = beef
3 = pork
4 = fish
... ...
2000 = vegetables

there are 7000+ products and i need to replace their numeric IDs (as you can see there are about 2000 individual IDs) with their corresponding text.

i'm sorry if this confuses anyone but i can't find better words to describe my situation for now.

 

[baitmaster]

welcome to the board

You might use VLOOKUP for this, if you are dealing with a list of items that need to be replaced with corresponding values from a lookup table

If your data is all over the place, and you want to essentially use Excel's Find and Replace feature numerous times, then let me know. I have some code that can do that on any number of items

 

[rc_schawel]

thanks baitmaster! it took me some time to figure out how to work vlookup but finally got it. thanks a lot. that must have saved 3 nights of work.