Troubleshooting Lookalike Companies and Distinct Count Issues

I'm having trouble trying to figure out how many companies in total I've got in a table. I've used the lookalike companies feature and am getting a fair number of lookalikes. I'm sending them to another new table, and each row has a different email address. All good and in the format that will work for my CRM. I need to know how many distinct companies are in the new table though. I have tried to use the Lookup Multiple Rows in Other Table feature, using the company URL row as a comparison row (also separately tried the Company Name row) and got 0 records back both tries, even though the first 2 rows in the column have the same URL and company name. Can anyone help me figure out what I'm messing up?