I need to run vlookup to compare two set of data and i want it to be automated.

[mikail]

I attached a file that contains two tabs.

In New Order tab, it contains a set of data that i received from supplier.I will receive the update daily.

My task is to register the records in our internal system.

Before doing that, i need to run vlookup to check if the new data new data alraedy created in our system by comparing the data in New Order with data in Registration tab.

If the record alraedy exist in Registration tab, the cell E will appear as Yes and if it is not, the result is No.

I have more that 3000 records and i'm repeating the same step everyday.I wish i can get this automated.

Any help is greatly appreciated.