Linking Data between worksheets

[meli42]

I have a list on sheet-1 that I want to move onto an excel calendar (that I created) based on DATE.

EX: I want to put the 7/4/18 event details (DATA in Column B) on the calendar.

What would be the formula?

Example below:
[TABLE="width: 500, align: left"]
<tbody>[TR]
[TD][/TD]
[TD]Column A[/TD]
[TD]Column B[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Date[/TD]
[TD]Details[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]7/4/2018[/TD]
[TD]Fireworks - 8 PM - The Hotel[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]7/15/2018[/TD]
[TD]The Gala - 5 PM - The Hotel Local[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]7/28/2018[/TD]
[TD]Breakfast - 9 AM - Founding Farmers[/TD]
[/TR]
</tbody>[/TABLE]

 

[bs0d]

I'm thinking a simple vlookup would work.

If Sheet1 had the events by date; and sheet2 included the calendar, then:

On Sheet2, in each cell that represents a date put a formula like this:

=VLOOKUP([reference calendar date cell],Sheet1!A:B, 2, FALSE)