Using Lookup Function to Search Entire Table in Excel

·

Using lookup function in another table, I want to see if something exists across that entire table, not a specific column. the function is making me choose just one column. is there a way to lookup the entire table instead?

4 comments

Channeled
APP
·
·
👋 Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!
LuisArturo
·
·
Hey there thanks for reaching out, currently we do not have an integration that can perform this action, however I can create a ticket to bring this idea up with the team to see if it can be added to Clay. The best alternative right now would be to open up the other Clay table that you are trying to search, in another window and then using the "search" option at the top of the table to look for the value you are searching for and make note of the column it is in order to add it to the Lookup integration if you want to add the column information to the current table at a future point. https://downloads.intercomcdn.com/i/o/1179629793/5cc3ce9d0692a5f2593e0d7c/image.png?expires=1726269300&signature=8d4e1da841acee4b1ea6f6310ff7339e05e04eb0b29dabce6be469cbea56fd49&req=dSEgH898lIZWWvMW1HO4zR71hyHSL6u3YDXRk886jAGDRCdnf71OfLRjNZ2b%0AqJYy%0A
Channeled
APP
·
·
We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!
Channeled
APP
·
·
Hi Jeremy! This thread was recently closed by our Support team. If you have a moment, please share your feedback: