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.
Join the most demanding and futuristic program- Data Analytics