Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MATCH A NUMBER IN A COLUMN WITH A COLUMN IN A DIFFERENT SHEET
I have two sheets on an excel file. One sheet lists appoximately 4000 names
and ssn# and test results. The other sheet lists 10000 names with ssn# and other test results. I want to bring in the first test results with the second test results and match on the SSN# which is at a different row location. (multiple tests for same student so no copy and paste) Example: First sheet: Second Sheet Last First SSN Result Last First SSN Result Jones John 555-55-5555 87 Smith Mike 777-77-7777 85 Black Jack 444-44-4444 65 White Mo 888-88-8888 83 Jones John 555-55-5555 __ So if, the SSN match, how can I get the 87 under the result column? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return text in Column A if Column B and Column K match | Excel Worksheet Functions | |||
MATCH A NUMBER AS THE SUM OF VALUES IN A COLUMN | Excel Worksheet Functions | |||
Display missing Part Number if Column A does not match column B | Excel Worksheet Functions | |||
Copying a column to a new sheet so that cells match. | Excel Worksheet Functions | |||
Need rows in Column A removed if they fully or partially match with any Column B row | Excel Discussion (Misc queries) |