Mulit Key lookup across multiple sheets

I have two very larges sheets (45,000 Row, BL colloums each). Each sheet has the same columns in the same order but the row data is not necessairly in the same order. I need to find the same order accross the two sheets using the Order id and line number. Neither of these two values are unique across either sheet but the two togeather should be unique. IE there are multiple order number 1457 on each sheet and there are multiple line number 4’s but there should only be one instance on each sheet of order 1457 with a line number of 4. Using this i need to see if the due date of that order has changed between the two sheets. I have tried useing VLookup but I dont know how to use it when the data row location is unkown. 

By: Matthew

Leave a Reply

Your email address will not be published. Required fields are marked *