How to select rows in a table corresponding to criteria that apply to several rows?

Copper Contributor

Hello,
I'm trying to select rows in a table according to criteria that appear in the first column of the table. The selection criterion is to correspond to a list (for example: a list of file numbers). In the table, the same criterium (i.e file numbers) may apply to several rows.

Thank you 

2 Replies

You don't say WHERE you want to do this.  If in a filter applied to a table, choose perhaps "Text filter" in the drop down and knock yourself out.

 

If you wanted to do so in a SPILL formula, try perhaps

 

=FILTER(ROW(myTable), IFNA(MATCH(INDEX(myTable,0,1),myCriteria,0),FALSE))

 

to receive the matching row numbers.

@ecovonrein 

 

Thank you for your answer.

 

I wanted to create a different table for the selected data.

I am going to try your suggestion. Could you please explain me what you mean with SPILL formula ?

 

Thank you again,

Françoise