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 mis...
excel
  • SergeiBaklan's avatar
    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"
)
SergioDCQ's avatar
SergioDCQ
Copper Contributor
Nov 20, 2020
XLookuo seems right. But how can I search 2 columns i the 1st field (first and,last name)?
SJ_EC's avatar
SJ_EC
Copper Contributor
Nov 20, 2020
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.

Resources