Class 34: Approx Match Copy Copy

Summary: In this video, Mr. Raj Singh Sir will teach you how to use APPROX MATCH Formula. This formula helps us to get an exact match as well as approx matches from the given data in the table.

Formulas: Use 0 in range lookup to get an exact match and 1 to get approx. match

=VLOOKUP(LOOKUP VALUE, TABLEARRAY, COLUMNINDEXNUMBER, RANGELOOKUP)

Conclusion: In this video, you learned how to APPROX MATCH and get the desired results in front of the charts/tables.