If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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" 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! |
#3
|
|||
|
|||
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! |
#4
|
|||
|
|||
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! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Vlookup to retrive HOW CAN I UPDATE | jpricesr | New Users | 1 | September 22nd, 2004 09:47 PM |
vlookup failure | wandap | Worksheet Functions | 1 | August 18th, 2004 06:55 PM |
VLOOKUP and IF statements | JAnderson | General Discussion | 2 | August 4th, 2004 11:39 PM |
Need help with VLOOKUP | Frank Kabel | Worksheet Functions | 4 | January 17th, 2004 11:24 PM |
VLookup Help | Robert | Worksheet Functions | 5 | December 3rd, 2003 12:57 AM |