Step 4 — VLOOKUP for 3 Seasons Fantasy Points

<–Step 3           Step 5–>

With the raw fantasy football stats converted into a PivotTable in Step 3, we can begin building our cheat sheet for the big draft.

First, create a new worksheet, by right-clicking any worksheet tab and selecting Insert.  Select Worksheet in the Insert window, and click OK.

 excel fantasy football spreadsheet nfl draft cheat sheet vlookup

Figure 4-1

Double-click the tab of the new worksheet, and change its title to “RB Cheat Sheet.”

 excel fantasy football spreadsheet nfl draft cheat sheet vlookup

Figure 4-2

Now, we could Copy and Paste all of the RB’s from the RB FP Year worksheet.  However, that’s over 200 RB’s to consider (and I’m not really interested in Xavier Omon’s performance on the field).  Instead, I’ll Copy and Paste only the starting RB’s, using a depth chart from thehuddle.com.

 excel fantasy football spreadsheet nfl draft cheat sheet vlookup

Figure 4-3

Type the column header “Avg. FP/Yr.” into cell C1.  Then, select cell C2, and click the Insert Function button (fx)…

 excel fantasy football spreadsheet nfl draft cheat sheet vlookup

Figure 4-4

Learn more Excel for Fantasy Football, now available in paperback and e-book.  Order now, before the draft!

<–Step 3           Step 5–>

fantasy football cheat sheet Excel spreadsheet pivottable vlookup rank tier raw data stats statisticsfantasy football cheat sheet Excel spreadsheet pivottable vlookup rank tier raw data stats statisticsExcel Fantasy Football Book iBook iBookstore iTunes iPad Cheat Sheet NFL

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s