What does "Excel Match Function- Download practice Sheet" cover?

Excel Match Function:- The Excel Match function is used to find out the position of the selected value in the selected array. The position of the selected…

Who is this guide meant for?

Class 11 and Class 12 commerce students, and CA Foundation aspirants, studying Excel Formula.

Can I test myself on "Excel Match Function- Download practice Sheet"?

Yes — this page includes a short interactive quiz so you can check your understanding straight away.

Excel Match Function- Download practice Sheet

⚡

Quick Overview & Key Takeaways

Focus Topic:Excel Match Function- Download practice Sheet

Estimated Reading Time:2 mins

Excel Match Function:- The Excel Match function is used to find out the position of the selected value in the selected array. The position of the selected…
Syllabus-aligned study material with detailed definitions, formats, and practical examples.
Interactive check: Includes a custom practice quiz at the bottom of the article to self-evaluate knowledge.

Excel Match Function:-

Match

The feature of "Match" function: –

With the help of Match Function, we can retrieve the position of the Selected value in the selected array and we can use this position further with index function and others also.
It helps in getting a particular position of a certain value in the selected array.

Explanation of Function:-

=MATCH(lookup_value, lookup_array, [match_type])

lookup_value: -lookup_array: -match_type: -

If we put the value "1" - The MATCH function will find the largest value that is less than or equal to value. You should be sure to sort your array in ascending order.
If we put the value "0" - The MATCH function will find the first value that is equal to value. The array can be sorted in any order.
If we put the value "-1" - The MATCH function will find the smallest value that is greater than or equal to value. You should be sure to sort your array in descending order.