Hello,

I have an Excel with importing data from Access DB from column A to N. Then,
column O and P I have a calculated VLOOKUP value based on column A.
Everytime, I refreshed the data, the last couple rows would return #REF!
which is the criteria value. How do I fix this issue? Thanks
Example:
=VLOOKUP(#REF!, Ref!$A$7:$C$18,2,FALSE), the correct formula is:
=VLOOKUP($A238, Ref!$A$7:$C$18,2,FALSE)