I have a Countif function that checks if two events happened within a certain timeframe of each other. If they do happen at similar times, I want to lookup their corresponding unique identifiers, but don't know how! A Vlookup wouldn't work because more criteria have to be filled....
I have attached an example file. Here, I wanted to see if a shirt was ordered one hour before or after a shoe order. How can I find the actual order number that corresponds with the shoe and shirt order pairing? (desired output is highlighted)
Bookmarks