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!

lookup 2 columns
 

Since you mentioned SUMIF that suggests you want a conditional sum but your
description sounds more like you want a conditional count.

I think a better more detailed explanation is needed. Tell us exactly where
the data is. Tell us what the "words" are. Give a small example.

--
Biff
Microsoft Excel MVP


wrote in message
...
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!