I've created a table in tab 1
The table has 2 columns
1 column for SSN
1 column for the persons name of the SSN
I've created a work schedule table in tab 2
I designed the table for 3 shifts and 6 days
I want to be able to enter the SSN in a shift cell and have the Name auto populate in cell next to it.

Accounting uses the SSN but I need to use the name.

Any thoughts on how to accomplish that with excel?

Thanks