VLOOKUP with Search/Match Function Help

[Jdugan4]

Hi!

I am trying to figure out a formula to search two data sets; I need to find how many clicks in column F match the Group columns AND the string (column E) contains the word in column A.

Can this be done? Any help is greatly appreciated, thanks!!


A B C D E F
WORD GROUP GROUP TEXT CLICKS
word1 Group1 Group1 String 23
word2 Group1 Group2 String 45
word3 Group2 Group1 String 12

[mehmetcik]

entering this formula using ctrl shift enter will tell you how many words in column a, contain the text in column d, multiplied by the number in column d.

So in my test, word1 and word2 matched and I got 35.

Please Login or Register  to view this content.