Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup across columns | Excel Worksheet Functions | |||
Lookup two different columns | Excel Worksheet Functions | |||
Lookup Two Columns - Again | Excel Worksheet Functions | |||
Lookup Two Columns | Excel Worksheet Functions | |||
Lookup a value using two columns | Excel Worksheet Functions |