Showing manually added data in EDI Table.

Good morning all,

I am having problably a small problem which i can not fix.

In Excel i made a table named "Announcement Tabel" with 2 columns

1 = Loading adresses (Text)

2 = Announcement times (Time)

As example Loadingadress "A" has an announcement time from 30 minutes (the time before the true loadingtime)

When i am having a new adress, i manualy adding the new data in the "Announcent Table" in Excel with the announcement time.

In Power BI i have a "Data Table" feeded by EDI. In this table is the realtion with the "Announcement Table" the name of the loadingadress.

Now my question is,

How can i create in the table "Data Table" 2 new columns which shows me:

Column 1 = Yes/No or empty

Only when Loading adress from "Announcement Table" from Excel matches whith Loading adress from "Data Table".

When the loading adress from "Announcement Table"  is not in the list from the "Data Table" then empty.

Column 2 = Announcement time

The Time value 1:1 from the "Announcement Table".

Can you guys help me?

Thanks,