I hate to reply to on my own threads... but it turns out that I didn't add the optional range_lookup parameter to my vlookup formulas... adding ,FALSE to all of them corrected the issue!