Thornton Melon 548 Posted August 27, 2004 Mike - I'm importing projections from another site. I'm starting with QBs. I used the VLOOKUP formula, and it worked fine for PaYd and PaTD, but I get "#REF!" for PaINT, RuYd and RuTD. Any thoughts? Thanks Share this post Link to post Share on other sites
Mike MacGregor 20 Posted August 30, 2004 Hi TM. How about you paste in the formulas you're using here and I'll see if there are any inconsistencies or something that doesn't look right. Share this post Link to post Share on other sites
Thornton Melon 548 Posted August 30, 2004 Hi TM. How about you paste in the formulas you're using here and I'll see if there are any inconsistencies or something that doesn't look right. Hi Mike. The formulas I'm using are: =VLOOKUP($C5,Sheet1!$A$2:$D$3,3,FALSE) for PaYd (This one works fine) =VLOOKUP($C5,Sheet1!$A$2:$D$3,4,FALSE) for PaTD (This one works fine, too) =VLOOKUP($C5,Sheet1!$A$2:$D$3,5,FALSE) for PaINT (Result is "#REF!") =VLOOKUP($C5,Sheet1!$A$2:$D$3,6,FALSE) for RuYd (Result is "#REF!") =VLOOKUP($C5,Sheet1!$A$2:$D$3,7,FALSE) for RuTD (Result is "#REF!") Here is an excerpt from the Excel spreadsheet of the imported projections: Player Team PaYd PaTD PaINT RuYd RuTD Daunte Culpepper MIN 4039 26.3 14.7 480 5.6 Peyton Manning IND 4374 31.3 12.9 68 .7 Michael Vick ATL 3184 17.8 14.9 76 7.0 Donovan McNabb PHI 3371 24.0 13.6 365 3.9 Share this post Link to post Share on other sites
Sturge33 0 Posted August 30, 2004 It looks like the problem is with the "$D$3" part of your formula. This references the last cell containing data for the formula to look up. Assuming you have 7 columns of data, it should read "$G$XXX". XXX should equal the last row of data for your sheet of projections. Your formula would probably look more like this: =VLOOKUP($C5,Sheet1!$A$2:$G$125,3,FALSE) This example would have the formula look up data in all cells ranging from cell A2 to cell G125. Hope this helps. Share this post Link to post Share on other sites
Mike MacGregor 20 Posted August 30, 2004 That's it! Thanks Sturge. The $A$2:$D$3 in my example in the help guide is a reference to the table the projections are being pulled from. The actual reference used should be the top left cell in that table (first player name) to the bottom right cell (last stat for last player). Share this post Link to post Share on other sites
Thornton Melon 548 Posted August 30, 2004 Bingo! Thank you, gentlemen. Share this post Link to post Share on other sites