Remember Me?

#1
January 13th 05, 10:11 PM
 excel idiot Posts: n/a
Matching data in one column to another

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?

#2
January 14th 05, 03:15 PM
 David Jessop Posts: n/a

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

"excel idiot" wrote:

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?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Dave1155 Excel Worksheet Functions 1 January 12th 05 06:55 PM Fletcher Excel Worksheet Functions 1 December 22nd 04 04:26 PM Doug Excel Worksheet Functions 2 December 9th 04 09:55 PM kman24 Excel Worksheet Functions 2 November 17th 04 03:09 PM pinar Excel Worksheet Functions 0 November 9th 04 12:47 PM

All times are GMT +1. The time now is 10:37 AM.