| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return value if two data points match
I want to return a value when two data points match.
For example, if in a table the value of "Committee" and "June" are found, I want to return the value in that same row in a different column. My table looks like this: Column A Column B Column C Committee June 2 Board July 4 Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Return value if two data points match
Hi,
let's assume that you enter Commitee in D1 and June in E1 and want the result in column F1 =sumproduct(--(D1=$A$1:$A$1000),--(E1=$B$1:$B$1000),$C$1:$C$1000) if this helps please click yes thanks "ptf" wrote: I want to return a value when two data points match. For example, if in a table the value of "Committee" and "June" are found, I want to return the value in that same row in a different column. My table looks like this: Column A Column B Column C Committee June 2 Board July 4 Thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Return value if two data points match
Use:
=SUM((A1:A2="Committee")*(B1:B2="June")*(C1:C2) but after you've typed it use Ctrl + Shift + Enter rather than just Enter. Sam "ptf" wrote: I want to return a value when two data points match. For example, if in a table the value of "Committee" and "June" are found, I want to return the value in that same row in a different column. My table looks like this: Column A Column B Column C Committee June 2 Board July 4 Thanks! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Return value if two data points match
=SUM((A1:A2="Committee")*(B1:B2="June")*(C1:C2))
(Bracket missing...) "ptf" wrote: I want to return a value when two data points match. For example, if in a table the value of "Committee" and "June" are found, I want to return the value in that same row in a different column. My table looks like this: Column A Column B Column C Committee June 2 Board July 4 Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup and match then return data from another sheet | Excel Worksheet Functions | |||
| Match data then comapre and return new data | Excel Worksheet Functions | |||
| Match two columns, return a third piece of data | Excel Discussion (Misc queries) | |||
| Match data in 2 columns and return data from 3rd column | Excel Worksheet Functions | |||
| LOOKUP two data sets for match - return 1 or 0 - Please help! | Excel Worksheet Functions | |||
Linear Mode
