| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match 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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Match cells with cells on another workbook
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. -- Allllen -- Allllen "James1976" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linked Cells Staying With Cells Once Linked Workbook Update. | Excel Worksheet Functions | |||
| Can references to cells be used as part of a workbook reference | Excel Discussion (Misc queries) | |||
| Match Cells in Worksheets and add data from one to another | Excel Discussion (Misc queries) | |||
| Moving cells to another workbook sequentially | Excel Discussion (Misc queries) | |||
| How do I save an Excel workbook so that cells referencing another. | Excel Discussion (Misc queries) | |||
Linear Mode
