+ Reply to Thread
Results 1 to 6 of 6

Vlookup with closest matchng date

  1. #1
    Registered User
    Join Date
    02-20-2018
    Location
    london
    MS-Off Ver
    excel 2010
    Posts
    13

    Exclamation Vlookup with closest matchng date

    Hi guys,

    I am using a vlookup to match dates between two sheets, the issue is that there are multiple dates/ rows of the ID i am matching with. I am Comparing 3 sets of dates with 3 others on another sheet. I do not necesarrily need the max or min date its more on if the ID matches, and the first date matches then extract the second date. At the moment 75% of the dates it extracts are the correct ones to compare and the rest are duplicates which have three completely different dates.

    I have attached a file to show what i mean and what i need extracted... Essentially if someone can show how to do a vlookup or match 2 Cells/Columns with two others AND then extract data i think that would work.

    Thanks
    Last edited by jexcel123; 06-17-2018 at 05:12 PM. Reason: Clarification and detail

  2. #2
    Registered User
    Join Date
    02-20-2018
    Location
    london
    MS-Off Ver
    excel 2010
    Posts
    13

    Re: Vlookup with closest matchng date

    file attached i hope it comes through
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    02-20-2018
    Location
    london
    MS-Off Ver
    excel 2010
    Posts
    13

    Exclamation Re: Vlookup with closest matchng date

    hi guys, essentially i need to do match two columns or cells with others and then if they match to retrieve the data.. hope that helps really need help.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    16,664

    Re: Vlookup with closest matchng date

    I have looked at your workbook and I am really sorry, but I have no idea what you are trying to do.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

  5. #5
    Registered User
    Join Date
    02-20-2018
    Location
    london
    MS-Off Ver
    excel 2010
    Posts
    13

    Re: Vlookup with closest matchng date

    Please check original post, reworded so understood better i hope.
    Last edited by jexcel123; 06-17-2018 at 05:13 PM.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    16,664

    Re: Vlookup with closest matchng date

    No, don't do that - if you do, it will be closed and you will be directed back here. Add clarification to THIS thread, please.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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