Sorry Chaz I don't think that I can help any more. It is easy enough to do
with a macro but I am reluctant to try that because I cannot test it with
xl97.

Regards,

OssieMac



"Chaz" wrote:

Thankyou but no go, it didn't bring up any dialogue box with info and would
only check that one sheet that I had open - probably coz its xl97.

Im really after a formula that I would be able to copy as there are over 100
values that i want to lookup. In my workbook I have all the values i wish to
look up on my first sheet in the first column and in the next column i would
like it to have the sheet reference/result of my formula. I have another 20
worksheets in the same workbook that I want the formula to check for the
specified value and return the worksheet name (or in my case i have named
each sheet with a date) so im really asking it to return what date(sheet) the
value is on. Some could be on multiple sheets so I need it to return all
dates/sheets related. Im not even sure that xl97 would be capable of doing
that.

I hope Im making sense, im rather a novice with formulas?? Are you able to
help still?

Chaz

"OssieMac" wrote:

I am not sure if this works with xl97 but it certainly works with later
versions.

Right click on one of the worksheet names at the bottom of the screen.
Click on select all sheets.
Select menu item Edit-Find.
Enter the text to find and then click on Find All.
If it works, you should have a list at the bottom of the dialogue box with
the sheets and cell addresses of all occurrences of the text. Click on any
one of them and it will take you to the cell.
You should be able to click on the cell and edit it without loosing the
dialogue box with the list. Note the value changes in the dialog box but you
don't loose the sheet name and cell address.

I will appreciate it if you let me know if this works in xl97.

Regards,

OssieMac

"Chaz" wrote:

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?