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.