I have a 2 columns and want to count the number of times there is a particular match. So I want to look in the table called "Table". In cell B2 (which is not in the table) I have a word. In cells C2:C10, also not in "Table" I have several words. What I want to do is search for every row in "Table" that contains the B2 value in column 1 and any of the values from C2:C10 in column 2.
So in B2 I have "Word" and in column C I have several words like "it", "as", "in", etc
The table would look like:
Word it
Word not
Doc as
Seven in
My formula should return a result of 1.
I've been experimenting with dcount, countif, etc, but I'm just not getting it.
Thanks!
Bookmarks