Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: Vlookup #REF error

  1. #1
    Board Regular
    Join Date
    Oct 2015
    Location
    New Hampshire
    Posts
    58
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Vlookup #REF error

    I am having a problem with my Vlookup formula I am hoping that I can get some help. The formula is on Sheet1 cell Y15. I am trying to do a lookup based on account number on sheet 1 and 2. on Sheet 1 the account number is in Column C the column header is C11. On sheet 2 the account # column is column B. In Cell Y15 on sheet 1 I want the address field from sheet 2 Column H when the account numbers match.
    Any help is appreciated.

    Code:
    =VLOOKUP(C11,Sheet1!C:C,Sheet2!H:H,FALSE)

  2. #2
    Board Regular 63falcondude's Avatar
    Join Date
    Jan 2016
    Posts
    3,572
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Vlookup #REF error

    Vlookup should be of the form =VLOOKUP(lookup value, table array, column index number (should be a number),FALSE)
    Last edited by 63falcondude; Jun 23rd, 2016 at 01:10 PM.

  3. #3
    Board Regular
    Join Date
    Oct 2015
    Location
    New Hampshire
    Posts
    58
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Vlookup #REF error

    Quote Originally Posted by 63falcondude View Post
    Vlookup should be of the form =VLOOKUP(lookup value, table array, column index number (should be a number),FALSE)

    I tried this and I get a #NA error
    =VLOOKUP(Sheet1!C15,Sheet2!A:H,3,FALSE)

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,663
    Post Thanks / Like
    Mentioned
    41 Post(s)
    Tagged
    8 Thread(s)

    Default Re: Vlookup #REF error

    Quote Originally Posted by vba317 View Post
    I tried this and I get a #NA error
    =VLOOKUP(Sheet1!C15,Sheet2!A:H,3,FALSE)
    This formula says: Look up C15 of Sheet1 in column A of Sheet2. If found, return the corresponding value from column C of Sheet2. Is this what you are after?
    Assuming too much and qualifying too much are two faces of the same problem.

  5. #5
    MrExcel MVP Jonmo1's Avatar
    Join Date
    Oct 2006
    Location
    Bryan, TX
    Posts
    44,054
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Vlookup #REF error

    Looking at your original attempted formula
    Quote Originally Posted by vba317 View Post
    Code:
    =VLOOKUP(C11,Sheet1!C:C,Sheet2!H:H,FALSE)
    It would seem you want
    =VLOOKUP(C11,Sheet1!C:H,6,FALSE)
    Use the MrExcel HTML Maker to post nicely formatted tables in your forum posts.
    Find a link in post number 31

    The more we learn, and the better we get at our trade, the easier it becomes to overlook the obvious.

    Life moves pretty fast. If you don't stop and look around once in a while, you could miss it.
    Ferris Bueller A.K.A. John Hughes, 1986

  6. #6
    Board Regular 63falcondude's Avatar
    Join Date
    Jan 2016
    Posts
    3,572
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Vlookup #REF error

    Quote Originally Posted by Jonmo1 View Post
    Looking at your original attempted formula


    It would seem you want
    =VLOOKUP(C11,Sheet1!C:H,6,FALSE)
    This is what I thought at first until I noticed the different sheets in his attempted formula.

    =VLOOKUP(C11,Sheet1!C:C,Sheet2!H:H,FALSE)
    Last edited by 63falcondude; Jun 23rd, 2016 at 02:27 PM.

  7. #7
    MrExcel MVP Jonmo1's Avatar
    Join Date
    Oct 2006
    Location
    Bryan, TX
    Posts
    44,054
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Vlookup #REF error

    Quote Originally Posted by 63falcondude View Post
    This is what I thought at first until I noticed the different sheets in his attempted formula.
    =VLOOKUP(C11,Sheet1!C:C,Sheet2!H:H,FALSE)
    I didn't even notice that.

    I think the lookup range should be sheet2 then
    Quote Originally Posted by Jonmo1 View Post
    Looking at your original attempted formula


    It would seem you want
    =VLOOKUP(C11,Sheet1!C:H,6,FALSE)
    That should be
    =VLOOKUP(C11,Sheet2!C:H,6,FALSE)
    Use the MrExcel HTML Maker to post nicely formatted tables in your forum posts.
    Find a link in post number 31

    The more we learn, and the better we get at our trade, the easier it becomes to overlook the obvious.

    Life moves pretty fast. If you don't stop and look around once in a while, you could miss it.
    Ferris Bueller A.K.A. John Hughes, 1986

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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