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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

auto formatting 3
pulling certain characters from a string of text 3
-- Creating a list of names 1
Extracting data 1
Sampling 5
using part of a cell to sort a list into groups 2
Unique records 1
UserForm or MsgBox to select from a list? 2

Back
Top