Hi, I read one of the thread on how actually do you do this.
What im trying to do is using a set of list (data dictionary) to group data. Reason using list is so I can expand the list in future.
I manage to use this but I want to slightly improve it.
If you look at the attached example, instead of the formula giving me the column E result i want it to give the column F result.![]()
=INDEX($E$2:$E$6,MATCH(TRUE,INDEX(ISNUMBER(SEARCH($E$2:$E$6,A2)),),0))
Your feedback is most welcome.
Bookmarks