Say your range to search was A1 to D100.
Enter the string to find in E1, then try this *array* formula:

=ADDRESS(MAX((A1:D100=E1)*ROW(A1:D100)),
MAX((A1:D100=E1)*COLUMN(A1:D100)),4)

--
Array formulas must be entered with CSE, <Ctrl <Shift <Enter, instead of
the regular <Enter, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually. Also, you must use CSE when
revising the formula.

BTW ... the cell reference returned by this formula is text, and cannot be
used as is, in another formula to reference that cell.

It must be wrapped in Indirect() to work as an actual cell reference.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Kevin" wrote in message
...
Hello all,

I would like to find a formula that will search for the cell containing
the
word "Doctor 1" and return the reference (location) of that cell (such as
A1
or R1C1).

thanks