Results 1 to 5 of 5

Thread: Vlookup not working?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jan 2018
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Vlookup not working?

    Hi guys, I've used Vlookups a few times and testing something here... why is this cell returning 0? Instead of the 6 that I'm thinking it should? Without the "IFERROR" it returns "N/A" Not sure why it's not grabbing the 6 from the holiday days as "paris" matches this row? Maybe I'm doing something very wrong. I just don't understand.


  2. #2
    Board Regular
    Join Date
    Dec 2004
    Location
    Chester, IL
    Posts
    2,643
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Vlookup not working?

    Your data is very small and hard/impossible to see. What is the formula? And what columns and row are the lookup value, and the expected result in?
    Home: XL16 on Win07

    Work: XL13 on Win07

    Any answer provided is based on this(these) condition(s).

    ------------------------------------------------

    Post your excel WS to the board - HTMLMaker Add-In

    ------------------------------------------------

    Always test any code posted on a COPY of your data. Most changes, when performed by coding, are not able to be undone.

  3. #3
    New Member
    Join Date
    Jan 2018
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Vlookup not working?

    Hi! Not sure why it came up so small!


    Last edited by Lmaonade; Feb 15th, 2018 at 05:49 AM.

  4. #4
    New Member
    Join Date
    Jan 2018
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Vlookup not working?

    Ok I think I figured it out. I guess I have to make the data start at the same colomn as the search. So for this test I would need to start the search data from Colomn E rather than from the whole table?

    I didn't know that the VLookup search data has to start at the same colomn.

  5. #5
    Board Regular JonXL's Avatar
    Join Date
    Feb 2018
    Posts
    216
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Vlookup not working?

    Quote Originally Posted by Lmaonade View Post
    Ok I think I figured it out. I guess I have to make the data start at the same colomn as the search. So for this test I would need to start the search data from Colomn E rather than from the whole table?

    I didn't know that the VLookup search data has to start at the same colomn.
    Yes, VLOOKUP searches the left-most column of the range you specify for the search value and returns the value in the cell of the same row x columns to the right.


    https://support.office.com/en-us/art...8-93a18ad188a1

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
  •