Hi all.
I have a done a table with the name of certain newspapers in the B column and their links in the C column
In the first column A using Hyperlink I combine both.


After I want to search a name in the first column A but as it is an hyperlink I cannot.
Any idea how I can do that?
Thanks, Adrian

Attached Files

Newspapers.xlsx (8.9 KB, 12 views)

Since you used column B to create the "friendly" hyperlink name, why can't you search for the name in column B instead?

Simply because I want the name WITH the link

Check if this is the way you want it

Decio

Attached Files

Newspapers Decio.xlsx (9.4 KB, 12 views)

Thanks for your time...but i do not understand. It doesn´t look like ti twill solve the issue

I am not sure I understand your request. Can you give an example of what your input and expected results are?

If you use a simple Match() function, it finds the name in the hyperlink result... e.g

=MATCH(B3,A1:A3,0) returns 3 which is correct.