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

Use COUNTIF

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

--

HTH

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


"Andy" <(E-Mail Removed)> wrote in message
news:437cb9d9$0$141$(E-Mail Removed)...
> 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
>
>