To create a lookup with a variable sheet name, you can use the VLOOKUP function together with the INDIRECT function In the example shown, the formula in C5 is = VLOOKUP( $B5,INDIRECT("'" & C$4 & "'!" & "B5C11"),2,0) Explanation In this example the goal is to create a lookup formula with a variable sheet nameTo return the sheet name in a cell, use CELL, FIND and MID in Excel There's no builtin function in Excel that can get the sheet name 1 The CELL function below returns the complete path, workbook name and current worksheet name Note instead of using A1, you can refer to any cell on the first worksheet to get the name of this worksheet Excel 365 Posts 126 Lookup Sheet name and return cell value in that sheet Hi All, I have been looking for a few days now and can't seem to find a formula to works this one out I have a macro enabled sheet and a formula which generates a list of sheets on the Main Sheet, beside that I reference data that I would like to return a value based
How To Make A Cell Value As Worksheet Tab Name In Excel Free Excel Tutorial
