grabbing adjacent cells

[Farfromunique]

I have a multiple sheet excel document, with data the I enter on the
first sheet, and static data on the second sheet. The second sheet is
in the format FName LName Social (with each of those being a seperate
column).
I want to be able to type in (on sheet 1) the social and have it pull
the FName and LName. How can I do this? Also, not all of my FName LName
pairs have socials!
Any help on this would be greatly appreciated! Thanks in advance,
FarFromUnique

 

[Max]

I have a multiple sheet excel document, with data the I enter on the
first sheet, and static data on the second sheet. The second sheet is
in the format FName LName Social (with each of those being a seperate
column).
I want to be able to type in (on sheet 1) the social and have it pull
the FName and LName. How can I do this? Also, not all of my FName LName
pairs have socials!

Assume source data is in sheet: X,
cols A to C, data from row2 down
col A = FNames
col B = LNames
col C = Social ID#s

In Sheet2,
assume the Social ID#s will be entered in A2 down

Put in B2:
=IF($A2="","",INDEX(X!A:A,MATCH($A2,X!$C:$C,0)))
Copy B2 to C2, then fill down as far as required

Cols B and C will extract the FNames and LNames corresponding
to the Social ID#s in col A (from the source data in X)