Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Unanswered: What does #Ref! Error Mean?

    I am using a vlookup to get data from a differnet table and I get that error. =VLOOKUP(Y6,Leases!A:H,COLUMN(),FALSE). that is the function I am using. Y6 = the source that you would search by. A = column of the unique value on search table. H= column of information I am retrieving. Any Ideas?

  2. #2
    Join Date
    Dec 2003
    San Diego, CA
    The #REF! error value occurs when a cell reference is not valid.

    It can be caused in this case by the use of COLUMN() if your column offset is not the same in your lookup and reference table. That can be adjusted with COLUMN()+/-Value, i.e. Column()+1. Or just use the actual column count. In this case, 8.

    Hope that helps,


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts