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.
|