Hi Lori,

The opening:

Even better

was, of course, a response to your closing question, and not, as might
appear to the casual seqential reader, a comment on the interposed response!

In fact David has provided you with a link to his excellent Vlookup
tutorial.


---
Regards,
Norman



"Norman Jones" wrote in message
...
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" wrote in message
...
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!