vlookup to index match

[mitchell36]

I am using vlookup to look at a data sheet, look at the date and then on another page check the date and if it corresponds post the data on the second page.

example of code
=VLOOKUP(B3,event,2,0)
example of data being viewed
4/01/2019 Cycling Australia Road Nationals 2019
3/01/2019 BBL - Melbourne Renegades v Adelaide Strikers GMHBA Stadium
3/01/2019 WBBL - Melbourne Renegades v Hobart Hurricanes GMHBA Stadium
2/01/2019 Summer Night Market
2/01/2019 Celebrity Solstice Station Pier, Port Melbourne
1/01/2019 New Year's Eve mass gathering
1/01/2019 Falls Festival Falls Festival

issue
Vlookup only looks at column a what I need is a formula that looks at all columns matches date and then applies the result to the cell in to the corresponding date. Help please obtw I am pretty basic in excel (at this time)

 

[aqeelnokia99]

=IFERROR(INDEX(Sheet1!$B$1:$B$7,AGGREGATE(15,6,ROW(Sheet1!$A$1:$A$7)-ROW(Sheet1!$A$1)+1/($A1=Sheet1!$A$1:$A$7),COLUMNS($A$1:A1))),"")