 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / October 2006Match cells with cells on another workbook
I have 2 workbooks: 15,000 names, addresses and refernece numbers. On another I have 100 names addresses and ref numbers. How do I find out if the 100 are on the workbook with 15,000? I need to use the refence numbers. On the small file, add a new column next to the ref numbers. Col A Col B Ref# New AS15 =vlookup(A1,Bigfile!A:A,1,0) AS20 =vlookup(A2,Bigfile!A:A,1,0) AS35 etc You just need to make sure you are looking in the right column in the big file. I put column A above but you can change that. Every reference that is found will be repeated. Anything not found will give you a #N/A error. you can then sort these or autofilter them to isolate them.  SignatureAllllen -- Allllen > I have 2 workbooks: 15,000 names, addresses and refernece numbers. On another > I have 100 names addresses and ref numbers. How do I find out if the 100 are > on the workbook with 15,000? I need to use the refence numbers. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.