big D 1 Posted August 13 I've tried updating the projection pal (.xlsm) stats linked to fantasy pros and the "QB Raw" stats update correctly but the vlookup in the "QB Clean" tab errors out. Not sure how to fix this formula. I beleive this is the same for all the "Clean" tabs. Thank you. Share this post Link to post Share on other sites
Mike MacGregor 20 Posted August 13 Hi big D. The FantasyPros projections have a small problem. They include the player's team in the same table cell as the player's name, so you need to do some data cleaning to get that out of there before the data will properly transfer to the Clean tab. Do you see that? Where it used to have "Josh Allen" on the Raw tab it is now "Josh Allen BUF". You can kind of see on the QB Raw tab how I cleaned the data in some of those columns to the right of the projections. First, copy the names and paste them to the right of the data (you can use the same columns I used before). Then highlight all of those names and split the data by space using Data > Text To Columns > Delimited > Space. Now combine the first + last names using a simple formula like "=N11&" "&O11" and copy, paste special it back to the original names on the left side. Clean tab look better now? Share this post Link to post Share on other sites
big D 1 Posted Friday at 01:29 PM Yes, that did it. Thank you Mike 1 Share this post Link to post Share on other sites
