Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Grab matching data and populate? | Excel Worksheet Functions | |||
filling a forumla down a column from data across a row | Excel Worksheet Functions | |||
Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions | |||
getting data from 2 excel sheets automatically | Excel Worksheet Functions |