Lookup a Column based on Unique ID and last transaction (date)

[smalik]

I posted this earlier but I can't find it under my posts. Therefore, please forgive me if this is a duplicate request.

I am trying to fill in the Address field from a transaction file. A unique ID can have multiple transactions. Each transaction comes with an Address. I need to pull the address from the latest transaction based on the date. In case the address is missing from the last transaction, can I pull the data from the transaction before? Obviously, if the ID in Column A does not find any transaction record, I need the cell to stay blank.

Looking to complete Column B using data in Columns D through F. The results I need are highlighted in tan color.

PS: I downloaded the Xl2BB add-in but MS Excel blocked the macro saying that the source could not be verified. Did I miss a step?

Thanks for your help in advance.

 

[Fluff]

Glad it's sorted & thanks for the feedback.