Address & Match function together (there may be an alternative function)

[Sashulik]

Hello All,

I'm new to the forum but wanted to ask a question about using the address function to find the exact cell of a unique string text.

I'm using the following command to find the address of a string i have in a different cell, is anyone familiar with such function and could please assist with how to use it properly?

=ADDRESS(MATCH("*$H$1*",A:A,0),1)

The string text is in cell H1, H2, H3.......(or on another sheet). The goal is to find the address of a cell containing the unique string text from cell H1, H2, H3.....(that entire column) in a sheet with 13,000 lines. Basically, could someone please assist with searching for a specific cell address of a string text referenced from another cell.

Thank you in advance,

~Alex

[Max, Singapore]

Perhaps something like this for the fuzzy search ..
Put this in say, I1, normal ENTER will do:
=IF(H1="","","A"&MATCH(TRUE,INDEX((ISNUMBER(SEARCH(H1,$A$1:$A$100))),),0))
Copy down
-------------------------------
Any good? Wave it, click the little star at the bottom left corner of my responses

[Pepe Le Mokko]

=IF(H1="","","A"&MATCH(TRUE,INDEX((ISNUMBER(SEARCH(H1,$A$1:$A$100))),),0))

Isn't it a bit of an overkill?

=IF(H1="","","a"&match("*"&h1&"*",$A1:$A100,0))

should work.

Also, if you need the cell reference for another formula, it is returned by

=index(a:a,match("*"&h1&"*",$A1:$A100,0)

(embedded in a formula)