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...
Hi Brady,
Please test this formula:
=INDEX((assumptions!$C$4:$I$7,assumptions!$C$10:$I$13),MATCH(R2,assumptions!$B$4:$B$7,0),MATCH(I2,assumptions!$C$3:$I$3,0),BE2)*BA2
And find it the attached file.
Regards
Thank you this worked well for me.