vlookup

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!

Hi Lori,
Hopefully this will help:
http://www.mvps.org/dmcritchie/excel/vlookup.htm
---
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

"Lori" <Lori@discussions.microsoft.com> wrote ...
> 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!

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!

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!
>
>