Reply To: Comparing sheet data

The cross sheet reference is on the whole column in the comparison sheet, in the source sheet it’s looking at the value on a row and seeing if it exists in the comparison sheet.

That’s how you want to do it, your not comparing 2 columns to each other, but looking if the value exists in the comparison sheet column.