Premium Only Content
![Excel Complex VLOOKUP to Create Description: Excel COUNTA, INDEX & MATCH for Blank Cells](https://1a-1791.com/video/s8/1/M/s/x/e/Msxek.qR4e-small-Excel-Complex-VLOOKUP-to-Cr.jpg)
Excel Complex VLOOKUP to Create Description: Excel COUNTA, INDEX & MATCH for Blank Cells
Feb 6, 2017 Excel Advanced Formulas & Features
Original video from Mike Girvin provided here: https://youtu.be/n09E8VfwWFc
Written Instructions: http://www.xelplus.com/index-dynamic-range/
In his video, Mike Girvin at ExcelisFun provides a very elegant and neat solution from Bill Szysz to the following problem lookup problem:
.
The end result is to come up with a description column in Excel, that includes the number of sub-items within a main item and also provides the description of the main item.
This video builds on the existing video by providing an alternate method using the COUNTA, INDEX and MATCH functions.
The formula shown here uses Excel's COUNTA function together with the INDEX function to create a dynamic range to count. The index function is used to provide a cell reference to the COUNTA function for the position of the top range as well as the position of the bottom range for each subset.
Excel's match function is used to look for or match for the first non empty cell (non blank cell) to provide the location of the top cell address and then the match function is used again to match for the first empty cell to provide that address for the bottom of the range to the COUNTA function.
★ 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/
-
1:57:44
The Charlie Kirk Show
3 hours agoThe Left's Mental Breakdown + Whistleblowing at USAID | Dr. Moyar, Sen. Paul, Turner | 2.11.2025
131K28 -
36:24
ArturRehi
11 hours agoThe Real Russian History No One Talks About
12.3K3 -
1:17:57
TheAlecLaceShow
4 hours agoGuests: Matt & Mercedes Schlapp, Jesse Kelly, AJ Rice | Trump Threatens Hamas | The Alec Lace Show
9.61K2 -
2:55:28
The Dana Show with Dana Loesch
3 hours agoJUDGE BLOCKS DOGE ACCESS AT TREASURY | The Dana Show LIVE On Rumble!
37.4K4 -
33:32
Grant Stinchfield
3 hours ago $2.61 earnedBig Pharma's Phony MAHA Commercial to Hook Out of Shape Americans
30.6K1 -
29:40
ROSE UNPLUGGED
17 hours agoThe Days of Noah and Lot: A Prophetic Parallel
9.49K1 -
1:00:36
The Dan Bongino Show
5 hours agoThe Liberal Meltdown Means They're Guilty In This Scandal (Ep. 2420) - 02/11/2025
722K1.4K -
51:47
The Rubin Report
4 hours agoElon Musk’s Tweet Reveals He’s Ready to Go Nuclear on Judge Stopping DOGE
75.2K123 -
2:04:58
Steven Crowder
6 hours ago🔴 Gulf of America Day: Why Trump's Renaming Spree is More Important than You Think
457K295 -
2:03:33
LFA TV
19 hours agoSWAMPY SHOWDOWN! | LIVE FROM AMERICA 2.11.25 11AM
74.6K26