Matching First/Last Name and Combining Info into New Sheet

[faceplant247]

I’m trying to combine information from two spreadsheets into one by matching the last name and first name from each.

So, for instance, in sheet 1, I have last name and first name in separate cells followed by info in cells after. In a separate sheet I have (in about half of the cases) the same Last Name and First Name followed by different info in cells after.

I want to combine the two sheets into one sheet by matching the Last Name and First Name followed by all of the pertinent info from both sheets.

If the Last and First Name is not present in both sheets I still want it to populate in the new sheet with Last and First name followed by the info from the 1 sheet.

Any help is appreciated.

[etaf]

how many columns follow the name
you could use match and index

assuming the names are entered into sheet1 and you want to copy from sheet 2 and sheet 3
and the data to copy across is in column c on both sheets

in sheet 1 C1 put
=INDEX(Sheet2!C1:C50, MATCH($A1&$B1, Sheet2!$A1:$A50& Sheet2!$B1:$B50,0))
use as an array - so control+shift+enter to change to an array formula - you get {} around the formula
in sheet 1 D1 put
=INDEX(Sheet3!C1:C50, MATCH($A1&$B1, Sheet3!$A1:$A50& Sheet3!$B1:$B50,0))
use as an array - so control+shift+enter to change to an array formula - you get {} around the formula

see attached