Friends,

So, here's the situation:

I have cells containing such info:

123-ABC-321
99999 nam 7
---, - jane 000

How can I lookup, for example, ABC, then based on it, replace the whole cell into a new cell to something like: Anderson?
Another example, for, nam, look up, nam, then replace the whole cell to a new cell to something like: Jason.

Am I making sense?

Please let me know if I need to explain or attach a file for better comprehension.

It's really that much I needed. To simply look up a string of text within a cell then replace the whole cell into something anything I would like it to be.