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

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

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

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