CODEWITHSUNDEEP
google-sheets
JY2k
JY2k

Reputation: 2909

Filter rows according to array in another tab

I am using the follow filter

=FILTER(A2:A,MATCH(A2:A,'sheet 1'!A2:A,0))

Within a custom formula but it's not responding. If I use

=FILTER(A2:A,MATCH(A2:A,I2:I,0))

It works fine.

Here is a link to a test sheet. When I add or remove letters to the first sheet the column under the Letters in the second sheet just bellow the orange respond accordingly. I cannot get the filter view to work with the same formula.

Upvotes: 1

Views: 530

Answers (2)

ttarchala
ttarchala

Reputation: 4567

Use the following for your filter view formula:

=match(A2:A, indirect("Sheet1!a1:a5"), 0)

Alas, it works only at the moment of applying the filter for the 1st time. Changing the values in Sheet1!a1:a5 will not automatically cause the filter to refresh. The only way to do that is via a =FILTER() formula, not via the UI filter view.

Upvotes: 1

iMarketingGuy
iMarketingGuy

Reputation: 696

Check your name of the sheet being referenced. Unless you changed the name it should be Sheet1!A2:A.

Upvotes: 0

Related Questions