Summary: In this video, Mr. Raj Singh Sir will teach you about the MATCH formula in advanced form. Here you will learn how to change the words shown in the matched rows.
Formulas: This formula is used when you want your desired text should display in the unmatched rows.
=IFERROR(MATCH(LOOKUP VALUE, LOOKUP ARRAY),” DATA NOT AV”)
This formula is used to join two names and match from the other chart/table.
=MATCH(CONCAT(LOOKUP VALUE), LOOKUP ARRAY, MATCH TYPE)
Conclusion: In this video, you learned how to use the MATCH formula in advanced form and to join and match data at the same time.