Forum Discussion
*SUGGESTIONS* Function for Dictionary-Like Tables / Invert Filter selection
More often than most things, we index-match Key-Value pairs. Now if the key-value pairs are in a Table, INDEX-MATCH looks really nice:
Table1:
| Key | Value |
| 1 | Panagiotis |
| 2 | Nikos |
| 4 | Kostas |
| data | Key | formula |
| 1235134 | 1 | =index(Table1[Value];match([@[Key]];Table1[Key];0)) |
| 12341234 | 4 | =index(Table1[Value];match([@[Key]];Table1[Key];0)) |
While that syntax is nice, it can get better:
FROM(Table1, "Value", "Key", [@[Key]]) !
How cool is that?
**
Also, add the option to invert filter selection. You added that in Windows Explorer, is it not the right time for the Excel too?
1 Reply
Great suggestion, recommend you post it to http://excel.uservoice.com so users can upvote it.
