VLOOKUP returns #REF!?

  • Thread starter Thread starter Cam
  • Start date Start date
C

Cam

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)
 
You'll have to figure out what you did to cause Excel to change the formula.
Excel puts in #REF when it can't find the original reference. For example,
if you deleted row 238, Excel will change your last formula to your second
last one. So, somewhere in the past you've destroyed the reference which is
causing the #Ref in the formula.

Regards,
Fred.
 
Back
Top