This worked a treat! many thanks!!

"Jacob Skaria" wrote:

If you are looking to retrive the matching data from ColC for the 2 criterias
metioned try the below. Please note that this is an array formula. You create
array formulas in the same way that you create other formulas, except you
press CTRL+SHIFT+ENTER to enter the formula. If successful in 'Formula Bar'
you can notice the curly braces at both ends like "{=<formula}"

=INDEX(Data!$C$2:$C$32001,MATCH(1,(Data!$A$2:$A$32 001=Sheet2!$A3)*
(Data!$B$2:$B$32001=H$1),0))

If this post helps click Yes
---------------
Jacob Skaria


"Dhazmo" wrote:


Parameters:
Column A = Text
Column B = Text
Column C = Numerical

My formula is:

=SUMPRODUCT((Data!$A$2:$A$32001=Sheet2!$A3)*(Data! $B$2:$B$32001=H$1),Data!$C$2:$C$32001)

This works fine except where the value/text I want returned in column C
looks like this "2008: 36" or "2008-36" - instead I receive "0" or "84" -
when I want the formula to return exactly what is in the cell.

Please help!!!