Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VLOOKUP not returning results | Excel Worksheet Functions | |||
Vlookup #N/A error due to formatting | Excel Worksheet Functions | |||
Need help with modifying VLookUp | Excel Discussion (Misc queries) | |||
carrying a hyper link when using the vlookup function | Excel Worksheet Functions | |||
VLOOKUP not working | Excel Worksheet Functions |