I still don't see the need for INDIRECT. VLOOKUP is certainly happy with a dynamic range.

Are you entering the name of a dynamic range in a cell?