Class 31: Using Index & Match Copy Copy

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