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?