Generally VLOOKUP() produces #REF! when the 3rd argument is larger than
the width of the 2nd argument table, e.g. in

=VLOOKUP(A1, C:E, 4, 0)

Thus you could examine whether the code deletes any columns prior to
refreshing data. No more ideas unless there is something more specific.

Does this help?
Kostis Vezerides