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
