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 in the table). For example, IF (specified cell="60%" AND specified cell="Efficiency" then $906), OR if (specified cell="60%" and specified cell="1 Bedroom" then $970). Any guidance would be appreciated. Thank you.
2 Replies
=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!
