Issue With Vlookup and Ranges

[melegaunt]

In all the time I was staring at the problem, the answer was looking right at me.

I figured it out.

[VBA Noob]

Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.