Help for multiple line look ups using my Index/Match formula

[tewell53]

Scenario: I have a workbook with two sheets (calendar, Events). On the Events sheet I have 4 columns; Date(A), Time(B) , Description(C), and Location(D). Now on my Calendar page I want to display the Events that correspond to Today(). My Index/match finds and displays the first match, But How to I code for days when there are multiple events. Here is my formula

=IFERROR(INDEX(Events,MATCH(TODAY(),Events!A2:A10,0),2),"Nothing Schudeled")

Thanks

 

[James006]

Hello,

You could test the following Array Formula :

=[TABLE="width: 84"]
<tbody>[TR]
  [TD="class: xl63, width: 84"]IF(ROWS(B$2:B2)<=COUNTIF(Events!$A$2:$A$10,Today()),INDEX(Events!$B$2:$B$10,SMALL(IF(Events!$A$2:$A$10=Today(),ROW(Events!$A$2:$A$10)-ROW(Events!$A$2)+1),ROWS(B$2:B2))),"")[/TD]
[/TR]
</tbody>[/TABLE]

Hope this will help

 

[James006]

Hello,

Once you have tested the formula ... feel free to share your comments ...