The Index function for finding a value buried in an avalanche of data in Excel
http://www.xlninja.com/2012/07/06/the...
The INDEX function is very useful for finding a specific value buried in thousands of data points.
Used in conjunction with the MATCH function, it makes the job of finding information quick and effective.
Watch this video to better understand how to use this very useful function in Excel!