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