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:

A

B

C

D

E

F

G

H

I

J

K

L

M

N

1

Keywords:

orange

smooth

metal

sleeve

2319

webbed

coated

alloy

voltage

taco

accessory

hardened

stain

2

3

Item Description:

Webbed metal bar for orange shelf

Blue titanium welding attachment

Orange stained metal dividing sleeve

Delicious steak taco

Voltage meter #2319

0048171 Hardened taco alloy (PFCJ777)

4

Number of times a listed keyword showed up:

3

0

4

1

2

3

<tbody>
</tbody>

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