Jump to content
Sign in to follow this  
bearwithbigclaws

Projection Pal Problems

Recommended Posts

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

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×