Clay Icon

Understanding Google Sheets Lookup Function Options

ยท
ยท

The Google Sheets Lookup function does not have the option of (Contains / Equals), so which one is it?

  • 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 Jeremy
    Jeremy
    ยท
    ยท

    I believe it automatically does equals. Is there any way to do contains for a gsheets lookup?

  • Avatar of Arturo O.
    Arturo O.
    ยท
    ยท

    Great question, Jeremy! I'll check this out for you, because their API docs don't specify it but chatGPT said this for now: The Google Sheets API itself does not provide direct functionality for "contains" or "exact match" filtering... They will simply return a range of cells or values from the spreadsheet as requested (based on the input restrictions). It does seem like it's mainly an equals statement though.

  • 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: