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/
-
32:14
daniellesmithab
16 hours agoNew Feature for Driver’s Licence and ID Cards
22.6K5 -
2:54:40
FreshandFit
13 hours agoChat Makes Pothead RAGE QUIT!!!
480K64 -
1:32:34
Badlands Media
16 hours agoBaseless Conspiracies Ep. 150: 9/11 Mysteries, Remote Pilots, and Hidden Agendas
95.2K34 -
5:32:35
Akademiks
7 hours agoWHERE IS WHAM????? Thug we Forgive u dawg.. Ralo vs Boosie. Charlie Kirk fallout. Cardi B album?
78.1K7 -
2:05:53
Inverted World Live
8 hours agoDeath Cult Terror Cells, NASA Bans Chinese Nationals | Ep. 108
72.2K11 -
2:43:57
TimcastIRL
9 hours agoVP Says No Unity With Democrats Celebrating Charlie Kirk Assassination, Left Confirmed | Timcast IRL
300K196 -
13:45
The Charlie Kirk Show
9 hours agoTPUSA AT ASU CANDLELIGHT VIGIL
237K69 -
55:10
Katie Miller Pod
9 hours ago $18.69 earnedEpisode 6 - Attorney General Pam Bondi | The Katie Miller Podcast
115K35 -
1:46:41
Man in America
14 hours agoLIVE: Assassin Story DOESN'T ADD UP! What Are They HIDING From Us?? | LET'S TALK
96.1K139 -
2:24:17
Barry Cunningham
10 hours agoFOR PRESIDENT TRUMP WILL TAKE NO PRISONERS AND THE LIBS SHOULD EXPECT NO MERCY!
130K78