[Challenge]How to get the tab name to use in formula

[minhhieule89]

Hello all, I want to use indirect formula to look up certain range in different sheets, is there a way to extract the sheet's name to use in the formula? it maybe easier than I thought but I haven't found any way to do that, thank you

 

[shg]

=MID(CELL("filename", Sheet1!A1), FIND("]", CELL("filename", Sheet1!A1)) + 1, 31)

... will return "Sheet1" if the workbook has been saved.

 

[minhhieule89]

=MID(CELL("filename", Sheet1!A1), FIND("]", CELL("filename", Sheet1!A1)) + 1, 31)

... will return "Sheet1" if the workbook has been saved.

perfect, I didn't think it was this easy, thank you