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
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
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)
Thank you so much it for your help.