Formula to copy information to the correct date?

My boss gave me a tough one today. I have 2 documents, one has our data on it next to dates where we made sales, the other has every date of the year with a column next to it ready to be populated.

As the data I'm copying across has less dates in total (as it only shows dates we sell) compared to where it needs to go which has every date of the year, I can't simply copy across.

You still with me here?

So I was hoping there's a kind sir / madam out of you guys who could help me acquire a formula which can check the dates match, then copy the data between 2 other cells if they do match.

I know I'm asking a lot, but I hope you can help.

I look forward to reading any responses/help.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize (remove any confidential) the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Try

=INDEX(Sheet2!$B$2:$B$1000,match(Sheet1!$A2,Sheet2!$A$2:$A$1000,0))

Dates in Column A on both Sheets

Data required in Column B of Sheet2

Output on Sheet1

Try

in F3

=IFERROR(INDEX($B$3:$B$6,MATCH($E3,$A$3:$A$6,0)),"")

Copy down: you will get blanks where there is no match.

That's absolutely perfect. I can sort this out now and adapt it for the real document. Thank you very much for all your help sir. I really appreciate it!