Multiple search criteria for copy and paste value in new sheet

[CapricornDec20]

Hello Guys
Please I am new to excel programming and would like to get started. Need help.
Can anyone help me with it, my boss gave an assignment I need to fill the final data sheet from the raw data sheet, if it have one search criteria for search and match i can use vlookup, but the problem is that its has 3 search criteria, City, store and day of the week. Can any one help me out for creating the excel macro, if data is short i can do it manually, but its a very huge data of 2000+ entries. data file is attached.

 

[Fluff]

In future please explain EXACTLY what you are trying to do in your first post, rather than constantly moving the goalposts.
s this is now totally different from your original question you will need to start a new thread.

 

[CapricornDec20]

In future please explain EXACTLY what you are trying to do in your first post, rather than constantly moving the goalposts.
s this is now totally different from your original question you will need to start a new thread.

Okay thanx, please don't mind, actually its a same question, for better understanding i shorten the data remove some of columns in both the data sets and present both the data sets in one sheet for people to better understand.

 

[CapricornDec20]

Okay thanx, please don't mind, actually its a same question, for better understanding i shorten the data remove some of columns in both the data sets and present both the data sets in one sheet for people to better understand.

and my requirements are still the same.

 

[Fluff]

for better understanding i shorten the data remove some of columns

Then how are we meant to supply something that works? We can only go on what you have shown & if that is nothing like your data then any solutions are unlikely to work.
You originally asked for something working in work sheet, now you say it's not only different sheets, but also different workbooks. That (IMO) is not the same.

 

[CapricornDec20]

These are 2 different files with same data I have mentioned in my first post. My requirements are the same that I shared in my first post. I just assembled 2 different files on one page for people to understand what I want. Just for the visibility... I appreciate you helped me out, thanks for that. If anything you didn't like it then I'm sorry for that.