Hire From Us

New Feature

Class 31: Using Index & Match Copy Copy

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

Please enable JavaScript in your browser to complete this form.

Enquire Now

Please enable JavaScript in your browser to complete this form.