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

Thread: Vlookup

  1. #1
    New Member
    Join Date
    Feb 2016
    Posts
    21
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Vlookup

    Trying to use a VLOOKUP to auto populate a cells if there is a match from column A.
    If Not then leave Not Found
    So if I but a number in A5 and that number is on any of the sheets with in the workbook then I want cell B5 to auto populate with what is in cell B5 from the sheet that has that number.
    Looking at 5 different sheets.
    Sheet2 will look at sheet1
    Sheet 3 will look at Sheet1 and Sheet2
    So far I have this( this is for sheet3)

    =IFERROR(VLOOKUP(A5,Week1!A:O,2),IFERROR(VLOOKUP(A5,Week2!A:O,2),IFERROR(VLOOKUP(A5,Week3!A:O,2),"Not Found")))
    But the Not Found does not stay in B5 when I enter a number in A5 that is not on the sheet. B5 populates with what was on sheet1 in that cell


  2. #2
    Board Regular
    Join Date
    Jul 2014
    Location
    Memphis, TN
    Posts
    2,057
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Vlookup

    It will be better to use Tables instead of the cell referencing. If you still wish to use cell referencing, you are creating a resource drain calling on the entire column ranges. Also, you should always indicate the lookup type rather than let the default choice be used. Exact match is best, FALSE, rather than the default True.
    Excel 2013, 2016 with PowerBI
    Knowing that it can be done is half the battle!

  3. #3
    New Member mas123's Avatar
    Join Date
    Apr 2010
    Location
    Egypt
    Posts
    41
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Vlookup

    hello
    the formula is good
    it gets vlookup result in sheet1 if not found searches sheet2 if not found searches sheet3
    so the first condition is true

  4. #4
    New Member
    Join Date
    Feb 2016
    Posts
    21
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Vlookup

    So on Sheet4 . If I use the above formal the Not Found does not stay in B5 when I enter a number in A5 that is not on the sheet.
    B5 populates with what was on sheet1 in that cell.
    I need it to tell me that, that number is not on any of the sheets

  5. #5
    New Member mas123's Avatar
    Join Date
    Apr 2010
    Location
    Egypt
    Posts
    41
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Vlookup

    use this for sheet4
    Code:
    =IFERROR(VLOOKUP(A5,Week1!A:O,2),IFERROR(VLOOKUP(A5,Week2!A:O,2),IFERROR(VLOOKUP(A5,Week3!A:O,2),IFERROR(VLOOKUP(A5,Week4!A:O,2),"Not Found"))))
    and rhis for sheet5
    Code:
    =IFERROR(VLOOKUP(A5,Week1!A:O,2),IFERROR(VLOOKUP(A5,Week2!A:O,2),IFERROR(VLOOKUP(A5,Week3!A:O,2),IFERROR(VLOOKUP(A5,Week4!A:O,2),IFERROR(VLOOKUP(A5,Week5!A:O,2),"Not Found"))))

  6. #6
    New Member
    Join Date
    Feb 2016
    Posts
    21
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Vlookup

    Thanks for the help.
    I did get it to work when I added the 'range_lookup' to my formula

User Tag List

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
  •  


DMCA.com