Forum Discussion
INDEX MATCH
Hi, I am trying to write a formula based on 3 different types of variables. I started by using an extremely long If(and statement and eventually excel wouldn't let me keep going. You can see what...
Brady,
=SUMPRODUCT(CHOOSE(BE2,assumptions!$C$4:$I$7,assumptions!$C$10:$I$13)*(assumptions!$B$4:$B$7=R2)*(assumptions!$C$3:$I$3=I2))*BA2
Thank you!
