How to have a list of items vertically arranged based on today's date?

[Indaxt]

Good evening everyone,

this is my very first post and I'm pretty new to Excel, so I will try and be as precise as possible. I have a table with two columns, one with a list of names and the other one with a list of dates.

I want to have a list of any of those names in another tab if the date shown for that name is today. See the following pictures:

If it helps, the table is called Table 55. I have tried with =XLOOKUP but it only returns the first value that it finds into every single cell of the column [C&NWL,C&NWL,C&NWL... rather than C&NWL, and [SWL]CH]. I want to be able to see all the diferent "trust" whose "date" is the same as either TODAY() or 'Today's Highlights!$B$1.

I hope this all makes sense and please accept my apologies if it's not very clear. I'm happy to provide more information if needed!

Thank you!

 

[Indaxt]

This is how far I got. How can I make it show the other results with that date? And how can I make it stop when there's no more "trust" with that value?

Sorry for the second post, and thank you for your time!

 

[Fluff]

Hi & welcome to MrExcel.
How about

=FILTER(Table55[Trust],Table55[Date]=B1)

But you have to put this in a normal range (not table) & it will spill down.

 

[Indaxt]

Hi & welcome to MrExcel.
How about

=FILTER(Table55[Trust],Table55[Date]=B1)

But you have to put this in a normal range (not table) & it will spill down.

Thank you!!! That works beautifully. Is it OK if I ask something else following this thread?
Now, when there is no match, it shows #CALC!. I don't know how I can make that formula so it doesn't show anything or shows "n/a" if there is no match. Any suggestions?

P.S.: I've tried IFERROR but it didn't work for me.

 

[Fluff]

How about

=FILTER(Table55[Trust],Table55[Date]=B1,"NA")

 

[Indaxt]

How about

=FILTER(Table55[Trust],Table55[Date]=B1,"NA")

Of course! Sorry and thank you once again!

 

[Fluff]

You're welcome & thanks for the feedback.