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"
)

SJ_EC

Copper Contributor

Nov 20, 2020

Google XLookup or Vlookup

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

Forum Discussion

Am looking to "merge" two excel spreadsheets

Resources