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" <normanjones@whereforartthou.com> wrote in message
news:OT6z73E$EHA.2192@TK2MSFTNGP14.phx.gbl...
> 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!
>
>