+ Reply to Thread
Results 1 to 13 of 13

comparing values and returning different column

Hybrid View

  1. #1
    Registered User
    Join Date
    10-05-2005
    Posts
    34

    I get #ref! error

    I get the #ref! error when I use the Vlookup function as outlined in the previous post. I have attached an example of the data.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    I see the error, and I initially advised you incorrectly.

    Your lookup range has to encompass all of the data you are looking in. You have:

    =VLOOKUP(B2,Sheet2!$A$1:$A$2000,2,FALSE)

    It should be

    =VLOOKUP(B2,Sheet2!$A$1:$B$2000,2,FALSE)

    Notice the lookup range has changed from A1:A1000 to A1:B1000

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1