For example, even though the Cavalleria pirate ship is on Excel row 16, it’s actually row 15 in our formula because our range begins on A2 and goes through I16. If A2 is row 1, then A16 is row ...

Use the IFERROR function to manage any errors that may arise from the INDEX and MATCH functions. Example: =IFERROR(INDEX ... When you’re working with Excel’s powerful INDEX and MATCH functions ...

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.