bearwithbigclaws 0 Posted August 23, 2013 Having an issue where the vlookup in the clean data tabs aren't pulling the info from the raw tab. First time experiencing anything like this with projection pal. I thought maybe at first the query wasn't updating, but copying to the compiler just copies over a bunch of null fields. Any ideas? I downloaded a fresh version off the site, same problem persists. Anyone have an idea? Share this post Link to post Share on other sites
Mike MacGregor 20 Posted August 24, 2013 Got your email and responded. All good? Share this post Link to post Share on other sites
bearwithbigclaws 0 Posted August 24, 2013 Yep, thanks Mike. It was indeed an issue with the player names. In case anyone else experiences something similar, you'll need to delete any trailing spaces from the player names (they weren't getting removed with TRIM). Ended up using =LEFT(A1 - LEN(A1-1)) and it was good to go. Share this post Link to post Share on other sites
