Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Finding the cell reference of a matching search value
I need to find a function or a series of functions, that will allow me to:
1. Search for a cell containing a particular string value (eg Cat) 2. Then have the function return to me the cell reference where the value was found (eg C$2). NOTE: The function needs to work across worksheets. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell reference manipulation | Excel Discussion (Misc queries) | |||
Finding Cell References | Excel Discussion (Misc queries) | |||
how to cell reference a Chart title | Charts and Charting in Excel | |||
international absulute cell reference | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |