I have 2 spreadsheets of unequal rows (Spreadsheet 1 = 20,000 rows,
Spreadsheet 2 = 5,000 rows). Can I use IF, VLOOKUP, MATCH, or INDEX (or a
combination of the 4) to systematically go through each cell in the 1st
column of spreadsheet 1, find a match from the 1st column of spreadsheet 2,
then place a value that correlates with that match in the 2nd column of
spreadsheet 1. What would this formula look like? Any help would be
appreciated. Thanks.