Forum Discussion
IF Functions
Hi, I have the following chart and looking to create a formula that solves for the rent amount if 2 conditions are met - (the AMI and the Unit Type both match to solve for the rent that corresponds i...
=INDEX($B$2:$F$5,MATCH(A8,$A$2:$A$5,0),MATCH(A9,$B$1:$F$1,0))
Maybe with this formula. If you don't work with Office365 or 2021 enter formula with ctrl+shift+enter.
=SUMPRODUCT(($A$2:$A$5=A8)*($B$1:$F$1=A9)*$B$2:$F$5)
Or maybe with this formula as shown in the attached file.
The INDEX formula works! True life saver. Thank you so much!