Jamesrr13Copper ContributorAug 06, 2023Using 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...Show More
SnowMan55Bronze ContributorAug 07, 2023Jamesrr13 If you are using Excel 365/Excel for the web, and as your "table" is sorted, try:=TAKE( FILTER(B$32:B$54, (C$32:C$54>$I$31)*(D$32:D$54>$I$32), "none"), 1, 1)(FILTER to get just motors that support the specified load, then TAKE just the first of those.)
