MATCH A NUMBER IN A COLUMN WITH A COLUMN IN A DIFFERENT SHEET

[L Curly]

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?

 

[Bernard Liengme]

Have a look in Help at VLOOKUP
Visit Debbie's page http://www.contextures.com/xlFunctions02.html
Then come back with any questions telling us what cell "Jones" is in on
Sheet 1 and "Smith" on Sheet2 so we can give you an exact formula
best wishes