Comparing today's date against another table to produce a list of items out of date.

Firstly, thanks for any suggestions you may give. I've had excellent help on here before and I cannot thank the community enough.

I have a spreadsheet with two tabs, "Out of Date" and master data. On "Out of Date" I want to display the items (neatly) that are out of date from the master data sheet, (Date of expiry, Location, Type).

I could do this by writing multiple if statements followed by multiple vlookups but I want to just display the out of date items.

i.e. I wish my spreadsheet to look like

A1 - Todays Date
A2 - Expired on, B2 - Location, C2 - Type

Is this possible without delving into VBA? I've looked for templates and had no success thus far.

I appreciate any comments or feedback. Thanks

What's the end goal with this request and not using a macro? You could just create a pivot table and only filter on items from your master sheet where the expired on < Today's date.