Gudangpictjp4ml

 Getting data from another spreadsheet based on a cell value might be quite useful for some projects and reports In this short article, I will show using Excel how you can get value from another worksheet based on a cell value I will pull data using two ways Using the Index and Match function combo and using VLOOKUP/HLOOKUP Excel functionTo 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 The Name Box in Excel is fastest way to create a named range Select a cell or a range of cells that you want to name Type a name into the Name Box Press the Enter key Q Tbn And9gcsksgsa50xppwwmkolubyjzrwkzlmxrrclr5zomqrzavxgemksl Usqp Cau Excel sheet name in cell value