PDA

View Full Version : [SOLVED] Find cell address



gsouza
09-27-2005, 06:42 AM
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
09-27-2005, 07:28 AM
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
09-27-2005, 09:08 AM
Thank you so much it for your help.