Category:

Course Description:

Three powerful Excel Formulas that lookup values in ranges, i.e. ranges that include lower bound and upper bound values. Method 1: First method uses the SUMIFS formula with greater than and smaller than as criteria. Method 2: SUMPRODUCT formula works great here too as it can work well with exceptions (and condition) Method 3: The next method uses INDEX and Match function to find the category that coincides with the defined boundary values. Instead of looking for the exact match, we will use the option “less than” in the match type argument. Method 4: A fourth option that came to my mind when I was creating the thumbnail for the video was the LOOKUP formula: =LOOKUP(B2,$H$2:$H$7,$G$2:$G$7) Course Length: 11:39 minutes Source: Leila Gharani

Thousands of courses

DisclaimerMany of the curated courses have been manually added into our Learning Management System, then enhanced with structure, descriptive, activities and consolidation,  referencing who the content creators are (where required). If you like the curated content from any creator and like their materials, please feel free to connect with them directly to explore their full libraries of paid programs. 

We will continue to add more curated quality content as well as increasing partnerships with creators to provide you with an all-in-one skills development platform. 

Book a demo now!

Tell us a bit about you. After review, you will receive an invite calendar where you can select your demo time.