Forum Discussion
SergioDCQ
Nov 20, 2020Copper Contributor
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 missing names.
I would like to bring over the contact info fields. Is there a formula to do this?
Thanks.
It's not necessary to add helper columns, that could be like
=XLOOKUP( Lastname & "=" & Firstname, LastnameColumn & "=" & FirstnameColumn, PhonenumberColumn, "no phone" )
5 Replies
- SergeiBaklanDiamond Contributor
It's not necessary to add helper columns, that could be like
=XLOOKUP( Lastname & "=" & Firstname, LastnameColumn & "=" & FirstnameColumn, PhonenumberColumn, "no phone" )
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.
- SJ_ECCopper ContributorGoogle XLookup or Vlookup