Formula in D2:
=IFERROR(INDEX(List,MATCH(,IF(ISERR(SEARCH(B$2,List)),COUNTIF(D$1:D1,List)),)),"")
Array formula: Press Ctrl+Shift+Enter, not just Enter
Copy down
Formula in D2:
=IFERROR(INDEX(List,MATCH(,IF(ISERR(SEARCH(B$2,List)),COUNTIF(D$1:D1,List)),)),"")
Array formula: Press Ctrl+Shift+Enter, not just Enter
Copy down
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks