Forum Discussion

tenorway's avatar
tenorway
Copper Contributor
Nov 20, 2019
Solved

Using search function with array input to categorize rows

Hi !   I am trying to use a combination of search, isnumber, match and index to categorize rows.  The category is supposed to be displayed on the same row.    I have seen the combination used fo...
Excel Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Nov 20, 2019

    tenorway 

    Practically the same that Jan Karel suggested

    =IFNA(INDEX($E$3:$E$6,MATCH(1,INDEX(--ISNUMBER(SEARCH($D$3:$D$6,B3)),0),0)),"")

    Perhaps that's non-array formula.

Twifoo's avatar
Twifoo
Silver Contributor
Nov 21, 2019

tenorway 

In the attached file, the wildcard lookup formula in C3 is: 

=IFNA(LOOKUP(2,1/(
COUNTIF(B3,"*"&D$3:D$6&"*")),
E$3:E$6),"Keyword Not Found")

When copied down rows, the foregoing formula returns results, as shown below: 

Resources