![](https://d3vm0xy31f4bap.cloudfront.net/wp-content/uploads/2022/03/Untitled-design-1-30.png)
Add Your Doubts: Click Here
Summary: In this video, Mr. Raj Singh Sir will teach you how to use both the commands INDEX and MATCH at the same time to get the desired results.
Formulas: Taking two different data to match
=MATCH(LOOKUP VALUE, LOOKUPARRAY, MATCH TYPE)
=MATCH(LOOKUP VALUE, LOOKUPARRAY, MATCH TYPE)
Using Index formula
=INDEX(ARRAY, ROW NUMBER, COLUMN NUMBER)
Conclusion: In this video, you learned how to merge both the formulas to get the results from the table