Results 1 to 5 of 5

Compare fields in two sheets ... return associated data to third sheet

Threaded View

  1. #5
    Registered User
    Join Date
    10-17-2008
    Location
    US
    Posts
    35

    Re: Compare fields in two sheets ... return associated data to third sheet

    Ok ... I'm getting closer ... Have been able to verify the rows that have a match in both sheets, but I am having one last issue. Comparing Remedy Tab column A with Compiled tab Column G (both concatenations) I have been able to return the line # or the ticket # from the Remedy tab.

    I am using the following code:

    =INDEX(Remedy!M:M,MATCH(G2,Remedy!A:A,0))
    The only issue remaining is that, when there are multiple matches, I need to figure out how to tell it to pick the match that is closest in time. The time on the Remedy tab (column F) will be slightly earlier than the time on the Transfers tab (column H). The difference should be mere seconds to a couple of minutes. I know that this topic hasn't been very popular ... probably because I'm having a hard time expressing what it is I am trying to do. but if anyone could help me, I would be eternally grateful.

    ~M

    *** Updated spreadsheet attached ... an example of a duplicate value is highlighted on all tabs in red ***
    Attached Files Attached Files

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