VLOOKUP HELP!
Here is the formula that I am using, VLOOKUP(C5,[football1.xls]Sheet1!$C$3:$P$66,7).
The formula is in Cell CJ5 of The Compiler, and the data that I am referring to is in a XCEL Spreadsheet, sorted by First Name of QB. the names are in column C and the data is in column H. In the compiler, Cell C5 is Donovan McNabb. In my spreadsheet, Donovan McNabb is in cell C19, the formula should pull data from cell I19, but gets the data from cell I18.
HELP!!!!!!!!!!!!!!!!!!