ok, looks like I was able to figure out my problem, I needed to extend my look up ranges and I also needed to add a key.
Thanks for pointing me in the right direction. I will mark this post as solved.