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