Forum Discussion
Solved
Help w/ Formula/Function
Hello I am using a PC with Windows/Office 365. Looking to build a formula that can compare B24 & B25 together against the table A33:38 & B33:B38 and if B26>B27 returns F33:38 or if B26<B27 returns ...
As variant
=XLOOKUP(1, (B24 = $A$33:$A$38) * (B25 = $B$33:$B$38 ), $F$33:$F$38 ) * (B26 >= B27)
=IF(B26<B27,0,
IF(AND(B24=A33,B25=B33),F33,
IF(AND(B24=A34,B25=B34),F34,
IF(AND(B24=A35,B25=B35),F35,
IF(AND(B24=A36,B25=B36),F36,
IF(AND(B24=A37,B25=B37),F37,
IF(AND(B24=A38,B25=B38),F38,"")))))))
Above IF formula achieves the same result. With Office365 or 2021 you can apply IFS formula as well.
Thanks!