Find cell address of specific text

[DMumme]

I am fairly advanced in Excel but can't seem to find a way to locate the cell address of specific text. For instance the text "Cat" appears only once somewhere in a known range. I am looking for a formula similar to =address or =Cell("address" or perhaps =vlookup that will let me input 1) the text Cat and 2)the range to look in and then have it return the address of where it finds the text "Cat". Is this possible?

[benishiryo]

hi DMumme. say the known range where "cat" is will be column C. then simply use:
=ADDRESS(MATCH("Cat",C:C,0),3)

or
="C"&MATCH("Cat",C:C,0)

[FlameRetired]

Say the known range is A1:O23 then array-enter this formula outside that range

Please Login or Register  to view this content.

Array formulas are not committed in the regular way. You commit by pressing and holding Ctrl + Shift as you hit Enter. You will know that it has been entered successfully when you can see curly braces {} around your formula in the formula bar. You do not type these in yourself. Excel does it for you.

[DMumme]

benishiryo
Works perfect. Many thanks!