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

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 Formulas are indispensable tools for  organizing data as well as creating reports and analyses.  I have found them most useful for creating reports from spreadsheet databases in which the data to be handled is already summarized.

Indeed, I’ve found them especially useful in  handling data summaries generated using SUMPRODUCT formulas . All my applications make generous use of these functions and most times they meet 80% of my needs. STUDY the formula using the notes provided on this page.

Next week  I will create and send you a step-by-step video demonstration/explanation of how this Index/Match Formula was built

Below: Screenshot of MS Excel worksheet with explanatory notes on how the Index/Match formula I created was used to generate the report shown.

Screenshot of MS Excel worksheet with explanatory notes on how the Index/Match formula I created was used to generate the report shown.

As usual, the workbook – with unprotected worksheets and VBA code modules was emailed to members of my Excel Heaven Visual Basic Automation Club. Click here to request a copy.

 

Source: ExcelVB

No Comments Yet

Leave a Reply