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