Matching data in one column to another

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

Guest

I have a worksheet set up with a person's name and SS#. I then have to
import (copy and paste) more data ( person's name and SS#) onto this
worksheet. I then have to match the names of the people to the ones that are
currently on the worksheet. I have been going through this manually and it
is taking me forever. Is there a formula where I can search the new data
against the inital data and have the new data line up on the same row as the
intial data, assuming it is an exact match?
 
Hi,

The =MATCH function is probably what you need. Suppose your existing data
is in A1:a20 and the new data in D1 then put

=MATCH(D1,A1:a20,0) into (say) F1 and this will either give you the position
of your data in the existing array, or #N/A if it doesn't exist.

HTH,

David Jessop
 
You must log in or register to reply here.

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

matching & combining data from seperate worksheets 2
Get location of match in another worksheet 2
Match data 4
Match Function 1
Take a range of data and copy to another by matching a unique id 1
matching 1 to 1 and 1 with variations... 3
subtotal, match? 10
Excel Copy cells from one worksheet to another workseet - increment row & do again 0

Back
Top