The INDEX method in Excel is a remarkably useful tool for locating data from a table. Instead of manually searching through cells, you can use INDEX, in conjunction with other equations, to dynamically display the https://http://datawitzz.com/index-function-how-to-use-it-in-excel/