How to reference worksheet by index number instead of name in Excel? For many Excel users, they tend to habitually rename the default worksheet name to their needed one. But in many cases, they need to reference the worksheet based on its index number rather than its real name. The following is an example of a formula that uses a cell reference in the Sheet2 worksheet in a workbook named Budget: = [Budget.xls]Sheet2!A1 If the workbook name in the reference includes one or more spaces, you must enclose it (and the sheet name) in single quotation marks. You can use the INDIRECT worksheet function to create linked references to other workbooks. You can reference each attribute of the reference (workbook name, worksheet name, and cell reference) individually by using the INDIRECT function to create a user-defined dynamic reference with worksheet cell references as inputs. More Information

Jul 14, 2016 · Return the name of a sheet into a cell using an Excel formula. This video tutorial explores the use of the CELL, MID and FIND functions to display the worksheet name in a cell. By doing this with ... The INDIRECT function works by evaluating text as a worksheet reference. Here, the name of each sheet is joined to the cell reference (A1) using concatenation: Once concatenation is done, the result is: The INDIRECT function will recognize the value in Cell A1 of Sheet1 and return the value. Aug 04, 2011 · Formula to reference a sheet name in a cell I have a file that has the sheet names in row 1(about 40). I want to write a formula that will reference the sheet in row one and not the actual sheet name so when I drag the formula it changes to the correct sheet name but I want the cell to float relative to the movement of the curser movement.