|Did you know, that as I sit here at my desk, I can not see what your workbook looks like?|
I don't know how your data is set up,
I have no clue as to what your vlookup formula reads,
nor do I know what your named ranges include or don't include
and the worst part is that my crystal ball is away for an upgrade this week and won't be back for several days.