Is there any way to search a sheet for a URL, if it is included in a hyperlink? The URL does not appear on the sheet, the text for the hyperlink does instead. I tried searching, given a URL, and its not finding anything on my sheets.
Any workaround for this? Perhaps there is a way to create a hidden column and a formula of sort that parses out the URL, so the URL can be searched via the hidden field?