Thanks Macropod for your reply!

I'm not sure what you mean by wrapping both expressions. Can you help me out with that with an example?

Also, when applying this VBA code, will a message pop up for each match that is found? That wouldn't be the best option because there's hundreds of rows where the ID's match.

Is it possible to write some text in the next column with the words "Match" or something like that?

Thanks again!

Rey