Hi I'm trying to collate some data depending if some specific words
are in 2 colums. I have one column with just one word to lookup which
works, but the other column has many words and I want it to return the
data from a third column depending if a specific word is in the 2nd
column. I have used SUMIF but it doesn't return any data as I think it
is looking for that word only, however there are many words in the
column.

can anyone help please?

Many thanks!