I have two sets of data on two sheets both including customer reference numbers, some of which match. I am trying to run a formula to identify every row in Sheet 2 where the customer reference number is also found on Sheet 1.
I can compare like for like cells but I can't seem to set a range for comparison i.e. Does Sheet 2 Cell B2 match any of Sheet 1 cells C2, C3, C4....C400.
Hope the above makes sense, any help would be greatly appreciated.