Is there anything in excel that can do this?

I work at a company that basically has a master of addresses that we file claims to and every time we get a new client they give us a code pertaining to a specific address which we in turn have to search every address to find our code in our system to tie it. I was wondering if excel had like a cross reference thing where I can list all of the addresses in our system and every time it comes up it will put our code on whatever address it is and leave everything that doesn't have matches blank? It seems far fetch but I am just trying to save time and I am not sure if there is a way it can be done or if it is completely out there? Thanks