Class 33: Using Index & Match Part 3 Copy Copy

Summary: In this video, Mr. Raj Singh Sir will teach you about the INDEX and MATCH formulas in advanced form. Here both the formula is used simultaneously to get the results.

Formula: =INDEX(ARRAY, MATCH(LOOKUPVALUE, LOOKUPARRAY, MATCH TYPE), MATCH(LOOKUPVALUE, LOOKUPARRAY, MATCH TYPE)

Conclusion: In this video, you learned how to use the INDEX and MATCH formula in the advanced form to get the desired results in
an expert way.