SD Nuggets™ » Organizing

…a multi-disciplinary blog for people passionate about reaching their goals!

On 1st April 2013, I began traveling slowly across West Africa as a Location Independent Multipreneur, sharing updates on this blog.But on 4th May 2014, my 9 year old domain was taken over by Aplus.net. THIS, is the "reincarnated" blog on my new domain: TayoSolagbade.com. Click "What Happened to SpontaneousDevelopmentDotCom ?" below :-))

[Excel-Heaven Tutorial 04] Extracting, Organizing, Analyzing and Presenting Data: Index/Match Formulas

Sunday, October 23, 2016

Warning: count(): Parameter must be an array or an object that implements Countable in /home1/tayoswdg/public_html/sdnuggets/wp-includes/class-wp-comment-query.php on line 399

Warning: count(): Parameter must be an array or an object that implements Countable in /home1/tayoswdg/public_html/sdnuggets/wp-includes/class-wp-comment-query.php on line 399
0 Comments

This is an INDEX/MATCH formula: =INDEX(setingsDBase,MATCH(D9,nfDrinksList,0),2) [See it used in the screenshot below] It is a powerful time saving formula constructed using 2 different functions – enabling timely and convenient extraction of data from a database while reducing the chances of user entry errors being made during routine data recording of product sales record Index/Match […]