Hello everyone,

I have been pulling hairs for the past few hours trying to think of the best way to do this. Firstly see below for a sample of my data.

Spreadsheet 1

Column A Column B Column C
01/01/2000 NY Giants 0.96
02/01/2000 Dallas 0.98
02/01/2000 Redskins 0.78


Spreadsheet 2
Column A Column B Column C
01/01/2000 At New York Giants 9
02/01/2000 At Dallas Cowboys 8
02/01/2000 At Washington Redskins 7

So what I want to do is do a vlookup of column A and column B of spreadsheet 1 on spreadsheet 2 so that it returns me column C (from spreadsheet 2). Note the date format is equal in both spreadsheets, however column B only contains part of the text. What is the best way to retrieve column C from spreadsheet 2. In reality, my spreadsheets are very large and contain 5 years worth of historical data and multiple columns.

Much appreciated for any guidance.