NKW6 Pt 3 INDEX and MATCH
Part 3 INDEX and MATCH The last in a set of three looking this time at INDEX and MATCH as a way to search a table and return the contents of a cell. This combination is a more versatile and perhaps more robust method of looking up data in a table than VLOOKUP. When I look at these two functions I almost always use them together. It looks somewhat complex but thinking through and breaking it down it becomes clear and there are significant advantages. First of all indexing is a method of pointing to something so if you imagine a table and you tell the programme which row to go to and which column to align to, you end up and an intersection and the contents of the cell are returned. This may have it’s uses but it is rather inflexible on its own. By introducing MATCH to replace a specified row or column number you are now making the function so much more flexible and powerful. The MATCH function looks at a range (either a column or row) and then sees whether the specified value