Table name excel formula 148930-Dynamic table name in excel formula
Choose Formulas on the side pane and then uncheck the Use table names in formulas box and press the Ok button Summarize with a PivotTable You can create a pivot table from your table in Table Tools Design tab, press the Summarize with PivotTable button found inReference the current sheet tab name in cell with Kutools for Excel With the Insert Workbook Information utility of Kutools for Excel, you can easily reference the sheet tab name in any cell you wantPlease do as follows 1 Click Kutools Plus > Workbook > Insert Workbook InformationSee screenshot 2 In the Insert Workbook Information dialog box, select Worksheet name in theExcel formula Abbreviate state names Exceljet Excel Details This formula relies on a table with columns for both the full state name and the 2letter abbreviationBecause we are using VLOOKUP, the full name must be in the first column For simplicity, the table has been named "states"VLOOKUP is configured to get the lookup value from column C excel s...