Forum Discussion
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....
=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.
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.