In this video I show how to use INDEX MATCH to pull DFS info from a Draftkings spreadsheet salary export instead of VLOOKUP.

VLOOKUP is easier but not as powerful. INDEX MATCH can look from left to right and right to left.

This is great when you have trouble pulling stats,
Check out my spreadsheet school for DFS for more videos like this to help you research better: http://www.spreadsheetschoolDFs.com

=INDEX(Sheet2!A:A,MATCH(Sheet3!B3,Sheet2!B:B,0))

http://www.optimizelineups.com To download our free spreadsheet lineup optimizers

Please take the opportunity to connect and share this video with your friends and family if you find it useful.