Skip to main content

Is it possible to use names but filter by code while using data blending via quick filters? In attached file there is an example of the problem. Data is like

code name

10 aaa

20 bbb

30 ccc

40 ddd

 

and

code name

10 aaa1

20 bbb

30 ccc3

40 ddd

But think of it like millions of rows of code and name could be changing day by day. I don't want to use static ways :)

 

I guess one option is to use sheets as a custom filter. But i wonder if there is better way of doing this.

2 answers
0/9000