Combining the Contents of Two Spreadsheets (INDEX-MATCH)

views comments

This video describes the use of Index-Matching to combine the contents of two spreadsheets. Presented by Larry Long, Management Analyst. ldlong@msu.edu.

Sample Formulas:
=INDEX(Column from which you want data on Sheet2, MATCH(Reference Cell on Sheet1, Column of Reference Cells on Sheet2,0))
=INDEX(Demographics!F:F, MATCH(Roster!A2, Demographics!A:A,0))