I’m adding new Google Row and also using lookup. At the moment the only way to look them up is Linkedin URL, as this is unique. Can you not lookup more columns e.g. First Name / Last Name? Only allows me to lookup 1 value… so I can’t do names.
No, you can only use one column at a time when performing lookups in another table. The lookup feature only allows filtering based on a single column, so you cannot combine multiple columns like First Name and Last Name for your search criteria.
Is that what you were looking for?
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.
um, are you trying to further filter down the lookup results based on name and linkedin both? or are you trying to expand the lookup results by looking at name OR linkedin?
I just want to ensure no duplications in the s/sheet
so it needs to lookup a value
i see, two separate lookup columns one using linkedin url another using full name and then a filter to exclude any results found in either - is the only way afaik