Forum Discussion

SpaceAge's avatar
SpaceAge
Copper Contributor
Mar 07, 2025

Matching columns in two spreadsheets

I have a larger spreadsheet with email addresses in one column and a lot of other demographic data in the other columns. I have a second, smaller, spreadsheet also with email addresses in one column....
excel
Formulas and Functions
SpaceAge's avatar
SpaceAge
Copper Contributor
Mar 10, 2025

Thanks for these, but they seem too complicated. I was able to use XMATCH to find the records I wanted (in the larger database, all the records have record numbers in the first column). Now I need to know how to return the results of an IF function so that if the logic test succeeds, the output is to copy the row of cells in the row in which the match occurred.  

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Mar 10, 2025
=XLOOKUP(I2,$A$2:$A$30,$C$2:$G$30)

Because you have access to XMATCH you could apply XLOOKUP for the expected results. XLOOKUP works between 2 spreadsheets as well.

 

  • SpaceAge's avatar
    SpaceAge
    Copper Contributor
    Mar 13, 2025

    Thanks, all for your help. I was able to use XLOOKUP to get what I needed, but I had to do each column separately. I guess I could have figured out how to automate the entire process, but I only needed 9 columns of date, so it just seemed easier to manually change the formula for each column. Here's the formula I used: =XLOOKUP(AE2,$E$2:$E$2344,$A$2:$A$2344). I changed the A to B, C, D, etc. for each column. The AE column had the data I wanted to compare to column E. 

Resources