bearwithbigclaws Posted August 23, 2013 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? Quote
Mike MacGregor Posted August 24, 2013 Posted August 24, 2013 Got your email and responded. All good? Quote
bearwithbigclaws Posted August 24, 2013 Author 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. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.