Add Your Doubts: Click Here
Summary: In this video, Mr. Raj Singh Sir will teach you about the INDEX and MATCH formula in advanced form. Here both the formula is not used simultaneously but changes the number and the amount from the table.
Process: (Can be done Vice Versa to obtain the number of products and months.) Select the Product > Data tab > Data validation ( Allow List, Source > Select all)
Condition Formatting : Select the Table (Excluding total) > Home > Condition Formatting > highlight cell rulers > Equal to (value,colour)
Conclusion: In this video, you learned how to use INDEX and MATCH the formula in the advanced form to get the desired results
and we also learned about condition formatting.
