| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
PLEASE HELP!! FORMULA TO RETURN A SHEETS NAME/REFERENCE.
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula reference~muliple sheets | Excel Discussion (Misc queries) | |||
| getting a formula to return the reference of a cell | Excel Worksheet Functions | |||
| Formula using 2 points of reference to return a value from a table | Excel Worksheet Functions | |||
| ADD A RETURN BUTTON WHEN GOING TO FORMULA REFERENCE LINKS | New Users to Excel | |||
| formula to return the value of a cell based on a looked up true reference | Excel Worksheet Functions | |||
Threaded Mode
