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

    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
    Location
    San Diego, CA
    Posts
    153
    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,

    Smitty

Posting Permissions

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