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!
|