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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"L Curly" <L wrote in message
...
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?