Yes! One sample:
Your search cell is "B2"
Your result cell is "B3", write there =iferror("row: " & match(b2,"D:D",0),"none")
Your files' names are from Cell D4 to down as many as needed.
>> Write something to Cell "B2" and You will get the result in "B3".
Your "search cell" worked for me but when I add the hyperlink to the file's name, the hyperlink doesn't appear on the result.Please check attachment
Regards
@hpbaxxter
You wrote before that
My file's name have a "hyperlink", I want to be able use the "hyperlink" in the result
Where are those "hyperlinks" in Your sample?
... test my vision
... there are no 'hyperlinks' but maybe works with those too.
Your "search cell" worked for me but when I add the hyperlink to the file's name, the hyperlink doesn't appear on the result.
I uploaded another example with the hyperlink
@hpbaxxter
You wrote before that
My file's name have a "hyperlink", I want to be able use the "hyperlink" in the result
Where are those "hyperlinks" in Your sample?
... test my vision
... there are no 'hyperlinks' but maybe works with those too.
@hpbaxxter ... hmm?
How ... I wrote code ... hmm?
You tried to change the cells ... where?
What did You try to do?
... maybe You really didn't know ... hmm
But, what is Your challenge?
I just checked and I found code at once!
I told what I changed in the original code.@hpbaxxter
Those 'blue's are same as in original codes.
>> Close file
>> ReOpen file
>> Test again
... or ReUpLoad the original code again.