Hi community,
I'm using the formula on E10 to calculate the quantity of slats I use depend on the size of the product
When I type any combination of these following numbers (150,200,250,300,350,400,450,500,550,600,650,700,800,900,1000,1100,1200,1350,1500,1650,1800,2000,2200,2400) on E3toE10 and F3toF10, the formula on E10 use the table bellow to search for the equivalent value(lookup) and sum all these values.
I tryied select on the lookup range the whole table but as I'm using arrays was returning wrong values(the table of heigh 100 is returning correct), So I decided to use a lookup for every single size different of 100, the problem is that I have around 300 different combinations and it would be 300 lookups on the same formula (when I type another lookup on the current formula the excel is not highlighting anymore), also the maximum SUM is 255.
Do you guys know how I can SUM these values easier using another formula or changing the array setup to use the whole table?
thank you
Bookmarks