Forum Discussion
Using Index and Match
I’m trying to create a formula in which you enter the kW and A of a motor and it will return the correct drive to use for that motor. Based on my understanding, the current formula I am using s...
=INDEX($B$32:$B$54,MATCH(1,(I31<$C$32:$C$54)*(I32<$D$32:$D$54),0))An alternative could be this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.