you might also take a look at Chip Pearson's page
Duplicates
http://www.cpearson.com/excel/duplic...gingDuplicates

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Biff" wrote in message ...
Hi!

There are many ways to do this. Here are a few:

Entered as an array, will return TRUE for duplicate, FALSE
for no duplicate:

=OR(A1:A5=B2)

Also entered as an array:

=IF(OR(A1:A5=B2),"duplicate","")

Entered normally:

=IF(ISNUMBER(INDEX(A1:A5,MATCH
(B2,A1:A5,0))),"duplicate","")

Biff

-----Original Message-----
I used either the vlookup, hlookup or lookup function a
long time ago but I
not sure how I used it.

I need to compare the contents found on column B with the
contents found on
column A to see if there are duplicates

If the value on B2 is found anywhere on A1:A5 I need it
to tell me that
there is a duplicate.

Can you help?
Thanks


Ademar Nunes


.