Write Cell to Column D if Column A contains name of client

I don’t know about the details of the flow, but my suggestion will be to get the mark “Successful” along with something unique like “Invoice number” for example and do simple “Vlookup” in the excel sheet.