Using Search and Lookup/Match/Index Functions

Hi Bob and Pepe, thanks for your help!

Bob, I tried your formula but it does not work on my side.
Basically, if the cell is blank or if the cell has "This company has been delisted on dd/mm/yyyy", I'd like to get "."
If there is a reason for the delisting (e.g., in liquidation), I'd like to see the corresponding number which is "1" in this case.

I've attached a revised file to make it more clear. Thanks!