Forum Discussion
Lookup for value based on sorted mapping table
Hi, I have been solving the categorization case for some time. The case is therefore: I have an mapping table (MapTable) where the order is important. Keyword Brand Index e-tron Ele...
PetrP , Not very clear to me.
You can also try like
Minx(filter(MapTable, SEARCH(MapTable[Keyword],Products[Product],,0)>0),MapTable[Brand])
amitchandak Your formula just searching by native search, not based on search keyword ranking (index).
This means I need to use such a mechanism that iterate all keywords in MapTable row by row by Index rank. E.g..: search e-tron, if not found then search sportback etc.. If any keyword is searched, use the Brand column.