Hi
Was wondering if it is possible to use a lookup or other tool for the
following scenario:
A column on a sheet contains a list of unique references in the format
AA111111
A 2nd sheet also contains a list of unique references in the same format,
some of which may match a reference on the 1st sheet.
Is it possible to use a lookup to compare the columns on the 1st and 2nd
sheet, and highlight any matches on the 2nd sheet?
Thanks
Andy
Bookmarks