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