Forum Discussion
Referencing Entire Workbook
I am working to have a cell that includes all of the sheet names in a workbook that a certain value is present. For example, value=8,456; tabs where value is present B3 and C1; cell reads: B3, C1 My ...
As a variant instead of using
=MID(CELL("filename"),FIND("]",CELL("filename",D5))+1,256)
you may extract sheet name from
=FORMULATEXT(D5)
SergeiBaklan wrote:As a variant instead of using
=MID(CELL("filename"),FIND("]",CELL("filename",D5))+1,256)you may extract sheet name from
=FORMULATEXT(D5)
That is a good idea, however, often the cells are set as values and no longer include the formulas. Any other ideas?
=MID(CELL("filename",'T1'!B1),FIND("]",CELL("filename",'T1'!B1))+1,256)if instead of D5 in formula you click on any cell in T1. For both CELL()
Or you would like to find in which sheet you have combination of "Travel" and 2900?
SergeiBaklan wrote:Or you would like to find in which sheet you have combination of "Travel" and 2900?
No I would just like the cell to return the tabnames in which the number is present.