Focus Topic:Excel Match Function- Download practice Sheet
Estimated Reading Time:2 mins
Comprehensive academic guide covering core concepts of Excel Match Function- Download practice Sheet.
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:-
The Excel Match function is used to find out the position of the selected value in the selected array. The position of the selected value may be exact matched, less than and more than from the value.
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:-
Now, We will explain the Arguments of the Function.
=MATCH(lookup_value, lookup_array, [match_type])
lookup_value: -
The lookup_value that value of which we want to know the position in the selected array.
lookup_array: -
The lookup_array that selected cells from which we want to know the position of the lookup_value.
match_type: -
The match_type are of three types show as following: -
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.
Example of Function: –
I will show you, how to apply the whole function. (using optional also).
From the following table get the position of the papers in the selected array: -
Excel-Match-Function-Example--minSolution:-
We will Apply the Match function and get the result. This is shown in the following steps: -
Step No. 1:-
We will write the “=Match( ” in the column of the result.
Excel-Match-Function-Example-Solution-1-minStep No. 2
Now select the cells with which you want to match the value with the selected array.
Excel-Match-Function-Example-Solution-2--minStep No. 3
Now select the array.
Excel-Match-Function-Example-Solution-3--minStep No. 4
Now apply matching condition
Example-Solution-4Step No. 5: -
Now, Copy and paste the function in all remaining cell to get the result.
Example-Solution-5Thanks Please Share and comment your feedback in the comment box.to buy the Microsoft Excel Click Here.
👤
Author & Educator
Sarbjit SinghB.Com and M.Com
Accounting & Commerce Educator
Sarbjit Singh holds a B.Com and M.Com degree and has over 12 years of teaching experience in double entry bookkeeping, financial accounting, and business studies.
❓ Frequently Asked Questions
What is the main topic of "Excel Match Function- Download practice Sheet"?
This guide covers "Excel Match Function- Download practice Sheet", focusing on key definitions, step-by-step concepts, applications, and revision guidelines relevant to Excel Formula.
Who can benefit from this guide on "Excel Match Function- Download practice Sheet"?
It is primarily curated for Class 11 and Class 12 high school commerce, accounting, and economics students, as well as aspirants preparing for board exams or CA Foundation.
Where can I practice questions related to "Excel Match Function- Download practice Sheet"?
You can take our custom-built interactive practice quiz directly on this page to test your understanding of "Excel Match Function- Download practice Sheet" instantly.