<ul><li>Use Association Table to Handle Interval Association</li><li>Example 1:</li><li>Calculate the values in column B of Sheet2 according to the rule: search Sheet1 with the quantity value of Sheet2, if the value is greater than StartQuantity and less than or equal to EndQuantity of a certain row, return the price of this row.</li><li>Example 2:</li><li>Calculate the values in Price column of Sheet3 according to the rule: search Sheet4 for the time interval where the hour number of Starttime is located, and take the price.</li></ul>

#131 — Use Association Table to Handle Interval Association

Discover more