Hey Anuj P. that was really helpful and it worked thanks.
I've got an issue with the "find people" part as I tested it with 50 contacts (total 47 companies) that I had. All these contacts were found from Apollo so I know that they have data on LinkedIn. I input the same job titles and country but in the new table only 20 people were found. In the end I only found a matching colleague in the same department and city for 5 out of 50 contacts.
The filters I used were:
company LinkedIn - to only pull the same companies
country - the countries of the list i pulled so it maches
job title (did not tick exact match) - i entered all available ones that matched
In the "job functions" section, i couldn't find a matching department for the job titles i wanted (sourcing, procurement, buyer, supply chain). Is there somewhere else to find this?