Forum Discussion

SergioDCQ's avatar
SergioDCQ
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 missing names.

 

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

 

Thanks.

 

 

  • SergioDCQ 

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

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

5 Replies

Resources