We cover how to use the MATCH Function in Excel in order to locate the position of a value within a data array. We start by using an Exact match to determine in which position each driver placed in the recent Silverstone F1 race. We then use the approximate match together with the INDEX function to determine which student obtained a given score in a test.

Subscribe for weekly Excel tutorials, techniques and examples:
[ Ссылка ]

Please share this video with others that may find it useful:
[ Ссылка ]

Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!

🌍 The Excel Hub website: [ Ссылка ]
📸 Instagram: [ Ссылка ]

ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.

For any enquiries, please contact:
theexcelhub@outlook.com

Overview: (0:00)
Exact Match: (0:39)
Approximate Match: Less Than: (1:26)
Approximate Match: Greater Than: (2:48)

свернуть