I have a spreadsheet that has LastName/FirstName in cells A1 and B1
respectively. In C1 I want to put a formula that looks at another
spreadsheet set up as a database to pull the last 4 numbers of the person's
SS#. Since there could be more than one person with the same last name, the
formula would have to reference both cells A1 and B1 to make sure it got the
correct SS#. I am just not sure this is doable.

Thank you for any help!