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? |
All times are GMT +1. The time now is 10:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com