Find cell address

[gsouza]

I know this is simple but I cant figure it out right now. If i have a word "cat" in range A1:A25 what formula do I put in cell B1 to find what address the word "CAT" is in.

Thank you in advance

[vonpookie]

If you're positive there is only one instance of the word in the specified range, I believe this should work:


=ADDRESS(MATCH("CAT",A1:A25,0),1)

[gsouza]

Thank you so much it for your help.