Having trouble with broken formulas after inserting rows in Excel? This article explains step-by-step how to fix them easily using formula copying—shared by an experienced Excel expert.

We will show you how to display the desired data by combining the INDEX function, which refers to data from a table on another sheet, and the MATCH function. How to Write the INDEX Function There are two ways to write the INDEX function. INDEX(array, row number,) INDEX(reference, row number, , )