VLOOKUP

[Guest]

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!

 

[David McRitchie]

Hi Lori,
Hopefully this will help:
http://www.mvps.org/dmcritchie/excel/vlookup.htm

 

[Norman Jones]

Hi Lori,

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

http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates

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.

 

[Norman Jones]

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.