Search google sheets using multilpe columns

(mda) #1

Hi,

While searching from google sheets, usual scenario is to provide “column” and “value”. All the rows where “column” matches the “value” will be selected.

What if I want to add another column to search criteria? i.e. give me all the rows where “column1” contains “value1” and “column2” contains “value2”.

Is this possible?

Thx,

Search Google Sheets across multiple column criteria?
(Karen Barker) #2

Hi,

Our search function only allows you to specify one column to be searched on. However, if you need to then narrow this down further, you can use a filter in your next task in the flow that specifies only use results if “column2” equals “value 2”.

Hope this helps. :slight_smile:

1 Like