Help with v-loomup

Copper Contributor
Hi evreyone,
Im using execl to follow my orders.
The thing is there is always new orders in my system.
Evrey months i have to download new excel files from the system and i wants to add the new excel infos to my old one without copy orders that i got there already.
The work circle need to be like have 1 excel file (with errors and meesages i leave in) and evrey month import to that file new orders from another files.
Same tables at both of the files, for example its like:
1. Adress 2. Order number 3. Date opend 4. status.
4 Replies
If possible please share the WB or some sample data along with results in expected format will help us to fix it !!
Cant post here real files but i've try to make demo files.
Sorry dear @Haimsalem posted image can't help me to understand the issue,,, I've demanded for the WB coz,,, I can check the formula considering data to decide how far is correct & what is the bug,,, it's large data set !!
There ia no bug,
I just dont know how to use vlookup in right way to get only the infromation i need.