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