Using INDEX() and MATCH() with Named Ranges

When working with a data set, naming the data set and then using INDEX() and MATCH() to find particular portions of the data is a very common task in Excel.