Forum Discussion

MOROBERT1987's avatar
MOROBERT1987
Copper Contributor
Jul 29, 2025

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 A and Column B from spreadsheet 2 then pull column C from spreadsheet 2 to spreadsheet 1. 

 

Any help is appreciated

community

1 Reply

Sort By
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Jul 31, 2025

    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.

Resources