Nov 19 2020 04:19 PM
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.
Nov 19 2020 04:44 PM
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.
Nov 19 2020 04:47 PM
Nov 20 2020 12:25 AM
Nov 20 2020 02:57 AM
SolutionIt's not necessary to add helper columns, that could be like
=XLOOKUP(
Lastname & "=" & Firstname,
LastnameColumn & "=" & FirstnameColumn,
PhonenumberColumn,
"no phone"
)
Nov 20 2020 02:57 AM
SolutionIt's not necessary to add helper columns, that could be like
=XLOOKUP(
Lastname & "=" & Firstname,
LastnameColumn & "=" & FirstnameColumn,
PhonenumberColumn,
"no phone"
)