+ Reply to Thread
Results 1 to 4 of 4

Closest match multiple variables

  1. #1
    Registered User
    Join Date
    02-22-2013
    Location
    AZ
    MS-Off Ver
    Excel 2010
    Posts
    2

    Closest match multiple variables

    Here is a sample of the data set I have:

    DIRMKT TIME YEAR --- DIRMKT TIME YEAR
    ALBDCA 0535 2012 --- AGSDCA 1940 2013
    BDADCA 1255 2012 --- ALBDCA 1153 2013
    BDLDCA 0620 2012 --- ALBDCA 1710 2013
    BDLDCA 0938 2012 --- BDADCA 1350 2013
    BDLDCA 1150 2012 --- BDLDCA 0620 2013
    BDLDCA 1338 2012 --- BDLDCA 0938 2013
    BDLDCA 1635 2012 --- BDLDCA 1152 2013
    BDLDCA 1939 2012 --- BDLDCA 1330 2013
    BHMDCA 1755 2012 --- BGRDCA 1727 2013

    I am trying to find a way to find the closest match of the time column in the right set of data to the corresponding time column in the first set, but only when the dirmkt is the same. For example, second from the bottom on the right set BDLDCA 1330 would return 1338 since that was the closest value in the left set of data with the SAME dirmkt. Any help would be amazing....I'm stuck. Thanks!!
    Last edited by zack7373; 03-11-2013 at 07:05 PM.

  2. #2
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,883

    Re: Closest match multiple variables

    Is this what you are looking for?
    Attached Files Attached Files
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  3. #3
    Registered User
    Join Date
    02-22-2013
    Location
    AZ
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Closest match multiple variables

    that looks like it did it. i haven't had much experience with the index/match nested functions like that. thank you for the help!

  4. #4
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,883

    Re: Closest match multiple variables

    You are welcome!
    Forgot to mention, it's an array formula. If you edit it you have to finish with Ctrl+Shift+Enter.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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