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 ***
Bookmarks