Crosscheck if the values mentioned in one range are present in refernce range through vba

There are two columns
A: Where values are mentioned manually
C: The list of expected values (reference values)

Could someone please help with a macro where
1. Each cell of range1 A:A(lastrow with data) is crosschecked with range2 C:C(lastrow with data)
2. If value isnot found then message like "value " & range1.value & "mentioned in" range1.address & "is not found in " & range2
3. exit sub on error

With attached sheet, it should show error for A5 as the value "CN" is not present in the column C

Thanks in advance for the help.

Some thing like this should work.

Please Login or Register  to view this content.