Curious, as your desired return from col C are text (not numbers)
doesn't your sumproduct expression:
SUMPRODUCT(--(A1:A3<=1050),--(B1:B3=1050),C1:C3)
return a zero?
I'd use this more generic index/match to do the job, normal ENTER:
=INDEX(C1:C3,MATCH(1,INDEX((A1:A3<=1050)*(B1:B3=1 050),),0))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"Carissa" wrote:
Unfortunately that didn't work, but I found a work around. I seperated the
min and max account values into two columns. Then I used the formula below
(ex. to look for account #1050 wich would fall into the 1001-2000 range)
SUMPRODUCT(--(A1:A3<=1050),--(B1:B3=1050),C1:C3)
Account Min: Account Max: Grouping:
0001 1000 Loans
1001 2000 Deposits
2001 3000 Equity