For a refresher tutorial or quick look up on INDEX and MATCH Functions in Excel, ExcelIsFun on Youtube explains it very clearly with great examples.

His explanation is clear and the examples are real-life and practical enough to let you understand the concepts pretty well.

He has done a good job to also provide free practice Excel Practice workbooks which you can use whiles following along with the tutorials. The workbooks can be freely downloaded from here:

ExcellsFun free Excel WorkBooks

You can watch the INDEX and MATCH tutorial from below or you can check him out on Youtube

 

 

Happy indexing and matching!

 

People Who Read The Above Post Also Read This:

VLOOKUP and HLOOKUP Excel Functions Great Quick Transact-SQL Server Tutorials – Quick Revision and General Understanding Default ThumbnailCheck Address Door Numbers Carefully in Excel Websites to Learn and Practice SQL for Free

Similar Posts

Python Pandas Pivot Table Index location Percentage calculation on Two columns – XlsxWriter pt2
| |

Python Pandas Pivot Table Index location Percentage calculation on Two columns – XlsxWriter pt2

Bydatapandasadmin

This is a just a bit of addition to a previous post, by formatting the Excel output further using the Python XlsxWriter package. The additions are : Colour formatting has been added to the Total Cost column The “Total Cost” has been given a money formatting The above uses row : column numeric values instead…

Assigning a Simple Button to a VBA Code – Excel Microsoft Visual Basic
|

Assigning a Simple Button to a VBA Code – Excel Microsoft Visual Basic

Bydatapandasadmin

This is a simple guide to create and assign a “button” to your simple VBA code. Credit to WiseOwlTutorials. You can check him on Youtube Let’s create a simple VBA code in a module A simple code like this will do for our example Sub NameIsNanaKofi() Worksheets.Add Range(“A1”).Value = “My Name is Nana Kofi”End Sub  …

| |

Automatically Open Excel and Send Report Using Batch and VBA

Bydatapandasadmin

  We can use Visual Basic codes to automate some reports in Excel. Below are some simple codes to do this. First this is a batch file to open our Excel report called “data report.xlsm”, assuming the report file is in the same folder as the batch file. You can schedule the time this batch file is…

Run Explore Frequency Distribution of Your Dataset in SAS Studio
|

Run Explore Frequency Distribution of Your Dataset in SAS Studio

Bydatapandasadmin

SAS Studio is a very powerful statistical program which are used by many corporations for various analytic and data science tasks. We briefly want to look at how we can check sum frequency statistics on some columns / attributes in our data. lets set the library name for our working directory where our dataset is…

Various Types of Basic Charts For Data Analysis and Exploration – Visualization and Meaning
| |

Various Types of Basic Charts For Data Analysis and Exploration – Visualization and Meaning

Bydatapandasadmin

Sometimes, you need some charts to explore your data and many times when your analysis is done and you want to report, you would most likely want to convey your message using charts and graphs. This is a quick look at some charts which are available and their names: We use this raw data in…

Leave a Reply

Your email address will not be published. Required fields are marked *