Extracting selected records from longer list

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top