2 worksheets, need to match and fill the data

i am not that advanced in excel and i was wondering if you can help me out.

i have 2 worksheets both sharing 3 forums of data. worksheet A needs to be completed with the data from worksheet b.

each row represents a person and the columns are account #, record #, ss#, name, date of service.

worksheet A is missing account #, record #, but has ss# name and date of service.
worksheet B has account #, record #, ss#, name, and date of service.

i need to fill the blanks in with the data from worksheet b to worksheet a......there are over a thousand line items so it would be impossible to copy it manually.

basically i need some how for worksheet b to fill the blanks in from worksheet a

hope that all makes sense

Can we match up SS#'s or are there duplicate entries of SS#'s? If so, are the SS# and Date of Service combination unique?

On both sheets, concatenate the SS# and Date columns into a separate columns

like: =A2&"_"&B2

where A2 contains first SS# and B2 contains first service date.

Copy formula down.

Then use INDEX/MATCH

e.g.

=INDEX('SheetB'!C:C,MATCH(E2,'SheetB'!$E:$E,0))

where SheetB is the sheet to get data from and column E of each sheet contains the concatenated ssn/date combo. Column C on sheetB would contain the account numbers, then copy down and to next column if you need data from next column too.

You are welcome,

If you are satisfied with the solution provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save