Back to all functions

Now we will be taking a look at three different ways to locate a specific value.
MATCH gives us the position of a given value. We’ll write Equals, MATCH, define what we are looking for, select the area, and then write a 0 to get an exact match. The value “Orange” is in position number three.
The INDEX function instead gives us the value in a specific position. We’ll write Equals Index, select the area, choose the row… and column. At the intersection of row 3 and column 2, we find the color Purple.
Out of a list of values, the CHOOSE function returns the value in a specific position. We’ll write Equals, Choose, give our position, and list the different values… In position number 2 in the list, we find the letter B.
In this lesson we have gone through three ways of locating values in a list: MATCH, INDEX, and CHOOSE.

Popular courses

The Excel Functions Guide

Deepen and develop your Excel Functions skills

Learn how to efficiently manage databases, clear text in cells, and retrieve values from other tables. The course also walks...

Excel Essentials

Get a better understanding of the Excel workflow

Learn to feel more comfortable in Excel. This course will help quickly develop your knowledge in Excel. Excel Essentials is...

Contact us for assistance in finding right course

Excel for your profession

The Excel course for Procurement and Logistic professionals

Excel for professionals working within procurement and logisticians

In cooperation with organisations and professionals within the industry, Learnesy have developed an Excel course that is adapted to those...

Looking for something custom made? Contact us and we will make sure to meet your requirements.