Search among hyperlinks

[abc3132]

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

[Sam Capricci]

I didn't have any problem, I typed into find "el pais" and hit find all and it came up with cells A1 and B1
I used the find >> Options >> within sheet, search by rows and look in: values.

[abc3132]

Thanks Sambo but I have not seen that. If you sear only in the column A "el pais" I do not get anything

[Mazzaropi]

abc3132, Good afternoon.

What kind of search are you looking for?

I tested it using a FIND option as our friend Sambo Kid (greetings from Brazil) and using formula.
All of them worked perfect.

Please, helps us to help you.

[Sam Capricci]

As Marcilio said, what kind of search are you looking for? I copied "El Pais" from cell B1 and pasted it in Find what: and I highlighted column A and it still finds cell A1, if I don't highlight the column it returns both A1 and B1. Click the binoculars on the home tab to open the "Find and Select" dropdown and select "Find" and it should work for you too.

[abc3132]

Obrigado Mazzaropi.
I speaks Portuguese but to keep the information to everyone.
As you can see in the attached PDF nothing happens. Maybe I´m doing something wrong...

[Sam Capricci]

switch it from Look in: formulas to values and try again.

[abc3132]

Thanks Sambo. You hit the nail

[Sam Capricci]

Glad that worked for you. Don't forget to mark the post as solved using the thread tools dropdown at the top of this post AND a big thank you for the rep!