.png){kind=logo}
Understanding Google Sheets Lookup Function Options
The Google Sheets Lookup function does not have the option of (Contains / Equals), so which one is it?
👋 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!
Jeremy··I believe it automatically does equals. Is there any way to do contains for a gsheets lookup?
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.
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!