SOLVED

Am looking to "merge" two excel spreadsheets

%3CLINGO-SUB%20id%3D%22lingo-sub-1914467%22%20slang%3D%22en-US%22%3EAm%20looking%20to%20%22merge%22%20two%20excel%20spreadsheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1914467%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20two%20spreadsheets.%20%26nbsp%3BThe%20one%20thing%20they%20both%20have%20in%20common%20is%20they%20both%20have%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSTRONG%3ELastname%20and%20Firstname%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20only%20one%20has%20Telephone%20and%20email%20addresses.%20%26nbsp%3BAnd%20of%20course%2C%20some%20of%20them%20are%20missing%20names.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20bring%20over%20the%20contact%20info%20fields.%20%26nbsp%3BIs%20there%20a%20formula%20to%20do%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1914467%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1914619%22%20slang%3D%22en-US%22%3ERe%3A%20Am%20looking%20to%20%22merge%22%20two%20excel%20spreadsheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1914619%22%20slang%3D%22en-US%22%3EGoogle%20XLookup%20or%20Vlookup%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1914723%22%20slang%3D%22en-US%22%3ERe%3A%20Am%20looking%20to%20%22merge%22%20two%20excel%20spreadsheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1914723%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F875577%22%20target%3D%22_blank%22%3E%40SergioDCQ%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20you%20are%20doing%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20believe%20XLOOKUP%20will%20help%20you%20achieve%20what%20are%20you%20looking%20for.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%2C%20follow%20the%20link%20below%20for%20more%20information.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fxlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929%23%3A~%3Atext%3DSyntax%2Cthe%2520closest%2520(approximate)%2520match.%26amp%3Btext%3DWhere%2520a%2520valid%2520match%2520is%2C%255Bif_not_found%255D%2520text%2520you%2520supply%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fxlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929%23%3A~%3Atext%3DSyntax%2Cthe%2520closest%2520(approximate)%2520match.%26amp%3Btext%3DWhere%2520a%2520valid%2520match%2520is%2C%255Bif_not_found%255D%2520text%2520you%2520supply%3C%2FA%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I have two spreadsheets.  The one thing they both have in common is they both have:

Lastname and Firstname 

 

But only one has Telephone and email addresses.  And of course, some of them are missing names.

 

I would like to bring over the contact info fields.  Is there a formula to do this?

 

Thanks.

 

 

5 Replies
Highlighted
Google XLookup or Vlookup
Highlighted

@SergioDCQ ,

 

I hope you are doing well.

 

I believe XLOOKUP will help you achieve what are you looking for.

 

Please, follow the link below for more information.

 

https://support.microsoft.com/en-us/office/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929#:~:....

Highlighted
XLookuo seems right. But how can I search 2 columns i the 1st field (first and,last name)?
Highlighted
Add a new column to the end of both sets of data and type =A2&B2. Replace cell references to match your data. Then use the new column as your lookup reference.
Highlighted
Best Response confirmed by SergioDCQ (New Contributor)
Solution

@SergioDCQ 

It's not necessary to add helper columns, that could be like

=XLOOKUP(
  Lastname & "=" & Firstname,
  LastnameColumn & "=" & FirstnameColumn,
  PhonenumberColumn,
  "no phone"
)