Finding/counting one list in another

Hey

I was wondering if I can somehow count how often a word in one list is found in anotherone?
Also I have two lists the first one is short, the second one is long, what I want: is to count how often a word from the short list match with words out of the long list.

table1
Word1,Word2,Word3

table2
Word1,Word4

I want to know if a word out of table2 is also in table1.


Thanks for help

Hello KS_ich_weiß_nicht,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.