Use COUNTIF

=IF(COUNTIF(Sheet1!A:A,A1)0),"Matched","")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Andy" wrote in message
o.uk...
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