Hi!

another spreadsheet set up as a database

Is that another separate file or another sheet in the same file?

How is the database setup?

Last name / First name in 2 cells?

How are the SS#'s entered? As the full xxx-xx-xxxx or just the last 4?

Many details to fill in!

Biff

"Cheri" wrote in message
...
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!