Search Two Ranges To See If The Same String Exists

[xander1981]

Thanks p45cal, done that but still populating each cell with "#N/A" even though the string is in both ranges.

[p45cal]

Then it's probably correct. There are probably similar entries but not exactly the same; there could be a small difference such as a leading or trailing space or some such. Can you provide a file where this is happening?