To understand why inserting a new row can break an Hlookup formula, remember how Excel HLOOKUP gets information about the lookup value - based on the row index number you specify. Supposing, you want to get sales figures based on the product ID. Those figures are in row 4, so you type...