Lookups

A

Andy

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
 
B

Bob Phillips

Use COUNTIF

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

--

HTH

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