Get Vlookup result matching with Multiple Columns

[T3as3r22]

Hi,

I want to have a value of order from the exact file but with the different date range report.
I want to match column A, B, C and D from the exact data from the other date range report and get the value of orders (column E) from the other file to this file.
Can we achieve that through a Vlookup or any other function?

Please let me know.

Thank you

 

[Anthony47]

It is very likely that it can be done...
But I didn't understand how "the other date range report" looks like: could you share an XL2BB sample, or at least a picture of them?

 

[T3as3r22]

It is very likely that it can be done...
But I didn't understand how "the other date range report" looks like: could you share an XL2BB sample, or at least a picture of them?

Here is the other date range report, looks like same, I need column E data matching column A,B, C and D.

 

[T3as3r22]

Here is the other date range report, looks like same, I need column E data matching column A,B, C and D.

Updated file

 

[Anthony47]

I am sorry, someone else smarter than me will surely understand and help