Search and Count Key Instances

[default_name]

Hello,

I have a table with a list of Keywords.
I also have a list of Item Descriptions.
I am trying to figure out how to count the number of times any of the keywords from the list are mentioned in each item description.

For random example:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A
[/TD]
[TD="align: center"]B
[/TD]
[TD="align: center"]C
[/TD]
[TD="align: center"]D
[/TD]
[TD="align: center"]E
[/TD]
[TD="align: center"]F
[/TD]
[TD="align: center"]G
[/TD]
[TD="align: center"]H
[/TD]
[TD="align: center"]I
[/TD]
[TD="align: center"]J
[/TD]
[TD="align: center"]K
[/TD]
[TD="align: center"]L
[/TD]
[TD="align: center"]M
[/TD]
[TD="align: center"]N
[/TD]
[/TR]
[TR]
[TD="align: center"]1
[/TD]
[TD]Keywords:
[/TD]
[TD]orange[/TD]
[TD]smooth[/TD]
[TD]metal[/TD]
[TD]sleeve[/TD]
[TD]2319[/TD]
[TD]webbed[/TD]
[TD]coated[/TD]
[TD]alloy[/TD]
[TD]voltage[/TD]
[TD]taco[/TD]
[TD]accessory[/TD]
[TD]hardened[/TD]
[TD]stain[/TD]
[/TR]
[TR]
[TD="align: center"]2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]3
[/TD]
[TD]Item Description:
[/TD]
[TD="align: center"]Webbed metal bar for orange shelf[/TD]
[TD="align: center"]Blue titanium welding attachment[/TD]
[TD="align: center"]Orange stained metal dividing sleeve[/TD]
[TD="align: center"]Delicious steak taco[/TD]
[TD="align: center"]Voltage meter #2319[/TD]
[TD="align: center"]0048171 Hardened taco alloy (PFCJ777)[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]4
[/TD]
[TD]Number of times a listed keyword showed up:[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]

I have tried doing a SUMPRODUCT and an ISNUMBER SEARCH but have gotten really turned around.
Thanks in advance for your help!

 

[Fluff]

How about
=SUMPRODUCT(--ISNUMBER(SEARCH($B$1:$N$1,B3)))

 

[default_name]

How about
=SUMPRODUCT(--ISNUMBER(SEARCH($B$1:$N$1,B3)))

Worked perfectly!! I didnt have the -- in front of ISNUMBER
Thanks for your help!

 

[Fluff]

You're welcome & thanks for the feedback