Clay Icon

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?

  • Avatar of Channeled
    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!

  • Avatar of LuisArturo
    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

  • Avatar of Channeled
    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!

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hi Jeremy! This thread was recently closed by our Support team. If you have a moment, please share your feedback: