Using MATCH and INDEX together

In this worksheet called index mass we're going to show you how you sometimes need …to use match and index together to come up with answers. …We could imagine this table on a different worksheet maybe even a …different workbook. What we'd like to be able to do here is …type in any month here or any product here based on the ones that are available. …And then come up with an answer as to how many of those items were sold for that …particular combination of a month and a particular item.…

We can begin by focusing first of all on the month. …And in the example here we have March set up as the month, cd drives is the item in question. …You can see both of those respectively in column E and in row 1. …So we can build this slowly or possibly come together ultimately in a single …formula using match and index. First of all let's figure out which month …is going to be appropriate here. We want to use this later to come up with …appropriate row number. So that's March there of course it could …be any of the 11 other months. We use the match function here to match …