Two tips:
1) When using VLookup always set the last parameter FALSE. That way, it will require an exact match and give you an error on names that don't match. Also, you don't have to sort the list first then. (if you then sort by the vlookup column though all the errors will sort together and you can quickly find the names you need to lookup)
2) Move all the sheets you are working with into one workbook. Right-Click the tab itself and select Move or Copy. This just makes your life a whole lot easier.
Bonus) When you go to your draft/auction and you want all those values to stay static, highlight the column hit Ctrl+C (copy) and then Edit > Paste Special and selet the button for "Values". That will get rid of the formulas and leave the values instead. At a draft, it's a lot faster, but you might not want to do it earlier when your projections might change.
Bonus #2) If you wrote a vlookup similar to
=VLOOKUP(A6, Hitters_02_01!A6:Y506, 9,FALSE)
because you maybe wanted the HRs for your player, as you copy down the list you might find some errors coming up. The problem is, if you fill down, the row numbers all increment, and if you fill right the column letters increment, so the next row down would look like:
=VLOOKUP(A7, Hitters_02_01!A7:Y507, 9,FALSE),
or the next row right would look like
=VLOOKUP(B6, Hitters_02_01!B6:Z506, 9,FALSE).
To fix this, add a $ before any values that won't change along the way. In this case, your range's rows and columns, and the lookup field's column (but not row):
=VLOOKUP($A6, $A$6:$Y$506, 9,FALSE)
Do you get the feeling I might have a ridiculously complex system of lookups and excel spreadsheets going?
)
