The INDIRECT function then coerces the text “Sheet1!A1” into a valid reference, which is passed into the SHEET function. The SHEET function then returns the current index for each sheet as listed.

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.