Index and Match...Maybe?

[Seven Twenty Two]

First post, so hopefully I explain what I am looking for clearly.

At work I will be running a report that I will copy and paste into this new Excel file (located in attachment A thru I).
I will then run the exact same report after I have been at work for 3 hours, I will copy and paste into this new Excel file (located in attachment K thru S)

Running this report twice will let me know if the Tray has moved to a new Station.
The Tray numbers won't always be in the same row, because if a Tray moves to a new Station that is not in my department, it will not show up on my report. This means I cannot rely on sorting the Tray number from small to large with the hopes of the Tray numbers being in the same row.

The end goal is to have a formula in column U that will look at column K and O and tell me if there is an exact match in columns A and E (again, if there is an exact match they may not be in the same row).
I'm guessing an Index & Match formula would be used for this, but I am not having any luck getting it done myself.

In the attachment, column V will be deleted - I just put that there to show what I would like the results to show... I plan on doing some Conditional Formatting to it as well, but I can figure that part out on my own.

Thank you in advance for helping me out.

[JohnTopley]

In U2

=IF(VLOOKUP($K2,$K$2:$O$9,5,FALSE)=VLOOKUP($K2,$A$2:$E$9,5,FALSE),"Did not move","Did Move")

[Seven Twenty Two]

Solved.

Thank you

[JohnTopley]

You're welcome.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED