Forum Discussion

Copper Contributor

Nov 20, 2020

Solved

Am looking to "merge" two excel spreadsheets

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 mis...

excel

SergeiBaklan

Nov 20, 2020

SergioDCQ

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

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

fsrezende

MCT

Nov 20, 2020

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#:~:text=Syntax,the%20closest%20(approximate)%20match.&text=Where%20a%20valid%20match%20is,%5Bif_not_found%5D%20text%20you%20supply.