Premium Only Content

Excel 3 Ways to Lookup within Boundaries: SUMIFS, SUMPRODUCT & INDEX
Feb 13, 2017 Excel Lookup Formulas
Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials
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)
Blogpost: http://www.xelplus.com/lookup-within-boundaries/
★ My Online Excel Courses ► https://courses.xelplus.com/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
-
14:11
Robbi On The Record
13 hours agoThe Trap of Identity Politics: How Division is Killing America
18.8K38 -
1:29:23
Nerdrotic
12 hours ago $19.49 earnedThe Turning Point | New UFO Video with Michael Collins | Forbidden Frontier #117
82.2K29 -
1:08:26
Sarah Westall
10 hours agoSuicide Pacts forming in Youth Social Media Groups - Discord, Reddit, TikTok w/ John Anthony
77.4K26 -
2:25:31
vivafrei
20 hours agoEp. 281: Charlie Kirk; Routh Trial; Charlotte Train; Bolsanaro Defense; SCOTUS & MORE!
157K232 -
2:55:38
Turning Point USA
11 hours agoWASHINGTON D.C. PRAYER VIGIL FOR CHARLIE KIRK
102K44 -
35:54
The Mel K Show
11 hours agoMel K & Tim James | Healing is an Inside Job | 9-14-25
75.6K4 -
3:06:33
IsaiahLCarter
14 hours ago $15.93 earnedCharlie Kirk, American Martyr (with Mikale Olson) || APOSTATE RADIO 028
84.9K29 -
16:43
Mrgunsngear
18 hours ago $13.33 earnedKimber 2K11 Pro Review 🇺🇸
61.4K14 -
13:40
Michael Button
1 day ago $4.08 earnedThe Strangest Theory of Human Evolution
54.3K31 -
10:19
Blackstone Griddles
1 day agoMahi-Mahi Fish Tacos on the Blackstone Griddle
38K3