Extracting selected records from longer list

[Guest]

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

 

[Guest]

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

 

[Guest]

Sorry I forgot to include the link in my first response:
http://www.ozgrid.com/Excel/excel-vlookup-formula.htm

Dave

 

[Guest]

Thank you! Vlookup was exactly what I needed.

Muchos gracias,

Heidi