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

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  …

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…

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…

Java Python R SQL Excel Compared Similarities For Data Science and Data Analytics – The Basics
| | | | |

Java Python R SQL Excel Compared Similarities For Data Science and Data Analytics – The Basics

Bydatapandasadmin

If you have ever worked with Java, Python, R, SQL, Excel and other Languages on a varied Data Science or Data Analytics projects, you will realise that all these languages have similar syntaxes, or at least, can achieve the same objective with very similar codes.   Below is a comparison and similarities of these various tools…

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…

Leave a Reply

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