lookup 2 columns
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!
|