Reading a value after pasting a link.

[Zac]

I've pasted a link on a sheet2 from sheet1.

When using the data filters on sheet 2, it shows the values in that column, but when I do a CTLR+F and enter a value I don't get a hit.

Why?

And can I by doing something else?

 

[Von Pookie]

What are the settings when you use Ctrl+F? Make sure you're not searching for 'match entire cell' if you want to find something within a string, for example.