Forum Discussion
MOROBERT1987
Jul 29, 2025Copper Contributor
Combining data from two different spreadsheets in Excel
Hi, I'm trying to take data from one excel spreadsheet and match it with another spreadsheet and VLOOKUP is not working properly. Example: If Column A and Column B from spreadsheet 1 matches Column ...
HansVogelaar
Jul 31, 2025MVP
It would have been better to ask this in the Excel forum.
Use a formula like this in C2 on spreadsheet 1:
=IFERROR(INDEX('spreadsheet 2'!$C$2:$C$1000, MATCH(1, ('spreadsheet 2'!$A$2:$A$1000=A2)*('spreadsheet 2'!$B$2:$B$1000=B2), 0)), "")
or in recent versions of Excel
=XLOOKUP(A2&B2, 'spreadsheet 2'!$A$2:$A$1000&'spreadsheet 2'!$B$2:$B$1000, 'spreadsheet 2'!$C$2:$C$1000, "")
Change spreadsheet 2 to the real name of that sheet, and adjust the ranges if the data extend below row 1000.