The formula bar displays the INDIRECT function syntax used to dynamically pull data from Sheet1 based on the text in cell B4.
Excel spreadsheet displaying the INDIRECT function formula =INDIRECT(B4&"!A1") for creating dynamic worksheet references.
Quality Assured by Worksheets Library Team
Reviewed for educational accuracy and age-appropriateness
ID: #347470