How To: Writing Index, Match and Index, Match, Match formulas

Writing a formula in Excel can be tricky, especially if you plan on writing one that has a bit of length to it and the INDEX and MATCH functions are no exception. There are a couple of things to keep in mind when writing formulas that will make it much simpler. Consider the following data:   …