Hi Lori,

Even better, see Chip Pearson's Highlighting Duplicates page at :

http://www.cpearson.com/excel/duplic...tingDuplicates

At the foot of that link, there are three sections:

Extracting Unique Entries

Extracting Values Common To Two Lists

Extracting Values On One List And Not Another

which should be of particular interest.

---
Regards,
Norman



"Lori" <Lori@discussions.microsoft.com> wrote in message
news:54DDB072-C6CA-4668-807E-622F05DC5F30@microsoft.com...
>I can't remember how to use VLookup! I have to worksheets with columns of
> common data I need to "merge" the two without duplicates. Can someone tell
> me
> how to write the formula in layman's terms please! Thank you!