+ Reply to Thread
Results 1 to 9 of 9

VLOOKUP Formula not working

  1. #1
    Forum Contributor
    Join Date
    04-22-2012
    Location
    Australia
    MS-Off Ver
    Excel 2016
    Posts
    313

    VLOOKUP Formula not working

    Hi all,

    On Sheet2 of the workbook attached I have a column (A:A) that copies one instance of a building ID number from Sheet1 (this building number will have numerous inputs of different issues noted during the inspection), basically I need Sheet2 column B:B to copy one instance of the date that the particular building was inspected, may be easier to understand when you look at my example. I have tried a code but can't get it to return the correct date...any ideas, as always thanks for any advice guys - Marco
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: VLOOKUP Formula not working

    try this formula

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.54 for Mac (home)
    Posts
    7,371

    Re: VLOOKUP Formula not working

    is this what you are looking for? ... =INDEX(Sheet1!B:B,MATCH(Sheet2!A3,Sheet1!D:D,0))
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  4. #4
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    '97, 2016
    Posts
    2,523

    Re: VLOOKUP Formula not working

    Sorry I'm late I was going w/ INDEX/MATCH - it's more flexible than VLOOKUP and takes less memory- but Sambo kid's already there.
    Last edited by leelnich; 05-14-2017 at 11:13 PM.

  5. #5
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,895

    Re: VLOOKUP Formula not working

    Try with index match
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Array formula [SHIFT+CTRL+ENTER]


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  6. #6
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: VLOOKUP Formula not working

    why do you need an array for this?

  7. #7
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,895

    Re: VLOOKUP Formula not working

    In another way.

  8. #8
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,391

    Re: VLOOKUP Formula not working

    Agree with humdingaling, that doesnt need to be array entered?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  9. #9
    Forum Contributor
    Join Date
    04-22-2012
    Location
    Australia
    MS-Off Ver
    Excel 2016
    Posts
    313

    Re: VLOOKUP Formula not working

    Apologies for the late response gentlemen, all solutions work perfectly!! (as always). Tweaked slightly to return a blank cell on error
    Please Login or Register  to view this content.
    Thank you all once again - Marco

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VLookup formula not working
    By lookupquestion2 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 05-05-2017, 09:52 AM
  2. Why is this VLOOKUP formula not working?
    By mfhaq77 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-14-2016, 12:34 AM
  3. [SOLVED] VLOOKUP Formula not working, please help!
    By andrew93hughes in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-27-2013, 04:39 AM
  4. [SOLVED] Vlookup formula not working
    By Ronmac in forum Excel Formulas & Functions
    Replies: 27
    Last Post: 08-25-2013, 06:00 PM
  5. Vlookup Formula not working...
    By Swambo in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-15-2011, 05:31 PM
  6. Vlookup formula not working
    By RightPlace in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-07-2011, 11:38 AM
  7. Why is my Vlookup formula not working?
    By Kleinstein in forum Excel General
    Replies: 2
    Last Post: 07-08-2010, 07:38 AM

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