SOLVED

Am looking to "merge" two excel spreadsheets

Copper 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
Google XLookup or Vlookup

@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#:~:....

XLookuo seems right. But how can I search 2 columns i the 1st field (first and,last name)?
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.
best response confirmed by SergioDCQ (Copper Contributor)
Solution

@SergioDCQ 

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

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

Accepted Solutions
best response confirmed by SergioDCQ (Copper Contributor)
Solution

@SergioDCQ 

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

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

View solution in original post