| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting selected records from longer list
We have a spreadsheet containing the details of over 10,000 samples.
Recently, a client sent us a list of samples IDs that they have, and would like us to send them the remaining samples that they DON'T have. How can I pull out just records (sample IDs) for the samples that are NOT on their list? Thanks, Heidi |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Extracting selected records from longer list
Use their list of IDs to run VLOOKUPs on your table of data. Any ID for
which a VLOOKUP returns #N/A would be one they don't have. See here for an explanation of how VLOOKUP works Dave -- Brevity is the soul of wit. "Heidi" wrote: We have a spreadsheet containing the details of over 10,000 samples. Recently, a client sent us a list of samples IDs that they have, and would like us to send them the remaining samples that they DON'T have. How can I pull out just records (sample IDs) for the samples that are NOT on their list? Thanks, Heidi |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Extracting selected records from longer list
Sorry I forgot to include the link in my first response:
http://www.ozgrid.com/Excel/excel-vlookup-formula.htm Dave -- Brevity is the soul of wit. "Heidi" wrote: We have a spreadsheet containing the details of over 10,000 samples. Recently, a client sent us a list of samples IDs that they have, and would like us to send them the remaining samples that they DON'T have. How can I pull out just records (sample IDs) for the samples that are NOT on their list? Thanks, Heidi |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Extracting selected records from longer list
Thank you! Vlookup was exactly what I needed.
Muchos gracias, Heidi "Dave F" wrote: Use their list of IDs to run VLOOKUPs on your table of data. Any ID for which a VLOOKUP returns #N/A would be one they don't have. See here for an explanation of how VLOOKUP works Dave -- Brevity is the soul of wit. "Heidi" wrote: We have a spreadsheet containing the details of over 10,000 samples. Recently, a client sent us a list of samples IDs that they have, and would like us to send them the remaining samples that they DON'T have. How can I pull out just records (sample IDs) for the samples that are NOT on their list? Thanks, Heidi |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set up a list of all of my music records | Excel Worksheet Functions | |||
| how do i make a drop down list of selected names no repeatition | Excel Worksheet Functions | |||
| Restructuring records into a list | Excel Worksheet Functions | |||
| Cells no longer highlight when selected | Excel Discussion (Misc queries) | |||
| Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
Linear Mode
