I have a large spreadsheet (like the sample below) and i need to be able to
look in the date column and if date (day and month only) is present then look
up the Opponents

The table is as per below and the date column is unique (15 years worth of
dates) so we could have 10 games all played on the (example) 24th of August
but for different years.

Date Opponents Result Score(us) Score(them)

Please help!!!!