Clay Icon

How to Lookup Specific Job Titles in a Database Efficiently

Β·
Β·

Hey Guys, Is it possible to lookup records based on a column input? I want to lookup multiple rows within a company but only lookup specific job titles. My workflow looks like this: #1 Identify the job function of a contact #2 Identify the job function they're hiring for on LinkedIn #3 Check a box if the function of the contact + the function they're hiring for matches #4 Write 3 contacts with the matched function (from the company) to another table Problem: Don't know how to lookup or write only 3 contacts to another table with the specific function (since the lookup multiple records) column searches for records randomly throughout the company Any solutions? Here's a video for context: https://www.loom.com/share/024adb3877234b09a274a0ba646ea6dd?sid=57bce2c7-b09f-4443-8eeb-b2b3157750ff