Conditionally Output No Records Found for Firm Name in Clay Table

I'd like to set a condition whereby if {Firm Name} doesn't exist in the table, the output should indicate "No Records Found". But if it does, it should detail the number of outputs where the dynamic variable exists more than once in my table. How would I do that in my Clay table? I've used the "Lookup Single Row in Other Table" to search for other tables but I don't think this would be used against the same table.