MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

matching data from 2 worksheets

  Asked By: Dora    Date: Jan 16    Category: MS Office    Views: 914

I'm currently working on a spreadsheet with 2 worksheets on it that
each have a name and a serial number. Both sheets have data
corresponding to each and I need to get them to one sheet.

This sounds easy, but there are an enormous amount of records (15000+)
so it can be very slow processing with just matching them linearly.

I tried using a binary search to drill through the sorted serial
numbers, but the problem is there are random letters within the
numbers that make it difficult to use comparisons (e.g. a serial could
be L2DX31).

Does anyone have an idea on how I can (relatively) quickly match
sheet1 and sheet2's data?



3 Answers Found

Answer #1    Answered By: Jaime Bowman     Answered On: Jan 16

Rather than automation, i think you can concatenate the two columns
to get a unique column and get a vlookup to compare data.

Answer #2    Answered By: Brandon Tucker     Answered On: Jan 16

ok I'll look into that..................

Answer #3    Answered By: Al Allen     Answered On: Jan 16

if u match 2 work sheet  u should v lookup
ie in fist sheet where u want the data  in that colum u put formula
=vlookup( first colum ,select secoun sheet,2,false) enter

Didn't find what you were looking for? Find more on matching data from 2 worksheets Or get search suggestion and latest updates.