Matching Lists to Array to get Results

[Excell1677]

Hello,

I'm looking for a method in which I can get a value based of an array matching the text string I attempted using an ISNumber search method but I ran into an error when trying to use an array instead of just the word. I enclosed an example of this problem in this post. Any help on this is appreciated...

Thanks

[Teethless mama]

J2: =LOOKUP(1E+99,SEARCH(C$2:C$6,I2),D$2:D$6)

copy down

[Jonmo1]

Try this

=LOOKUP(2^15,SEARCH($C$2:$C$6,I2),$D$2:$D$6)

Note:
There cannot be any blanks in C2:C6

[Excell1677]

@Jonmo1 and @Teethless mama

Thank You both for your solutions I found they both work efficiently well...

[Jonmo1]

You're welcome.