Index Match is a method of data analysis that can be used to query and index information within an Excel spreadsheet. In this video we walk through how to use this technique to efficiently query a table of margin information from Lee's Painting Company. It involves combining index and match functions, which collect data from a specific row or column index second argument, respectively. By using the index match method, we are able to accurately deliver key insights on margin performance with relative ease.