Fixed the issue. What happened was Vlookup was referencing the numbers as text while the other excel sheet I was using referenced it as integers. I added INT(cell) function and everything fell into place.

Thanks for your help though Palmetto!