ExcelBanter - View Single Post

Howard R[_2_]

Thank you so much.

"T. Valko" wrote:

Assume Sheet2 A1:B350 is your list of names and the corresponding SSN's.

Sheet1 A1 = R. Howard

Enter this formula in Sheet1 B1 to get the SSN:

=IF(COUNTIF(Sheet2!A$1:A$350,A1),VLOOKUP(A1,Sheet2 !A$1:B$350,2,0),"")

Biff

"Howard R" <Howard wrote in message
...
Hello, I work for a large company and do my department payroll in Excel
and
then hand it in to the general payroll department. In one given column "A"
I
have the employees' First initial and last name and in another given
column
"B" I have the employees' social security numbers. Is it possible to put
my
list of about 350 names and social numbers on the payroll page, hide it,
and
then format the cells or put in a formula or macro in column B so that the
correct social security number pops up to correspond to whichever name I
have
in column A. Thank you in advance for any feedback.