I have 2 spreadsheets. SS 1 has 8000 names and SSN's with first names in column A, last names in B, and SSN's in C. SS 2 has 600 names with first names in A and last in B but no SSN. All of the names on SS 2 are on SA 1. I need to be able to find the names from SS 2 on SS 1 and enter the SSN into column C of SS 2. I can combine the 2 SS's if needed.
Hi
There's no need to combine them.
First since you're going to want to match using first & last names, in D1 of SS1 enter
Formula:
=A1&B1
and copy down
Do the same in D1 on SS2
With both open in memory add the following formula into C1 on SS 2 and copy down.
Formula:
=IFERROR(INDEX('[SS 1.xlsx]Sheet 1'!C:C,MATCH(D1,'[SS 1.xlsx]Sheet 1'!D:D,False),1),"No Match")
Change the 'Sheet 1' reference as necessary.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
thriftyhiker 
Register To Reply
Bookmarks