Forum Discussion
merging 2 spreadsheets with different rows
I have 2 spreadsheets. Spreadsheet 1 has a lot of data (35 columns and 1600+ rows). Spreadsheet 2 does not have as much data (4 columns and 1400+ rows) but one of the columns needs to be merged into ...
=IFERROR(INDEX($H$3:$H$12,MATCH(1,(A3=$F$3:$F$12)*(B3=$G$3:$G$12),0)),"")You can apply this formula for the sample data. The formula can be adapted to the actual size of the data and additional columns don't interfere with the formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021.