I am trying to find a formula in Exel 97 so that I am able to find a text
value on multiple sheets in a workbook and it will return the name of the
sheet for me. I have two spreadsheets open and want to find out what sheet/s
a cell reference is on: example. xyz is on sheet ?? and sheet ?? there are
mutiple sheets which can have that reference on them but for me to go through
them all would take days. Is this possible to do in a formula?