Notifications
Clear all
Topic starter
Hello, Please I need help with the index-match function in the attached. I do not want to use CSE so it can be updated by anyone despite their proficiency in Excel. I inserted the wildcard (*) because the categories have different descriptions. Please assist.
Thanks in advance.
Posted : 12/01/2021 6:43 pm
It will only find the first occurrence but this might help
=INDEX(E2:E8,MATCH(H3&"*"&H4&"*",C2:C8&D2:D8,0))
Posted : 13/01/2021 2:33 am
You could use:
=LOOKUP(2,1/SEARCH(H4,$D$3:$D$8)/SEARCH(H3,C3:C8),E3:E8)
which doesn't require wildcards to be entered for a partial match.
Posted : 13/01/2021 5:22 am
