I need to look at text in a cell in range A and see if it exists (in any form) in range B (I would like to be able to select the range a and range b with a popup box if possible) The values don't match, so it needs to look at the first cell in the range A and see if the text exists in any cell in range B. If the Range A cell text exists in any cell in range B, then concatenate two cells together (the original range A cell value and the one to its left) and copy the concatenate into an empty cell next to the range B cell that the range A text was found in range B. I put in an example in the zip file.

An bhfuil sé seo indéanta fiú?