#1
|
|||
|
|||
Searching among hyperlinks
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 |
#2
|
||||
|
||||
Since you used column B to create the "friendly" hyperlink name, why can't you search for the name in column B instead?
|
#3
|
|||
|
|||
Simply because I want the name WITH the link
|
#4
|
|||
|
|||
Check if this is the way you want it
Decio |
#5
|
|||
|
|||
Thanks for your time...but i do not understand. It doesn´t look like ti twill solve the issue
|
#6
|
||||
|
||||
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. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
searching a range using a value in another cell | derohanes | Excel | 7 | 05-11-2015 03:01 PM |
Searching for Dupes | Gef | Excel | 7 | 03-02-2015 12:48 PM |
Searching hyperlinks | PuddinPie | Word | 1 | 05-27-2011 02:02 AM |
Backwards Searching Using a Formula | OTPM | Excel | 5 | 05-17-2011 09:17 AM |
effective searching | mar999 | Office | 1 | 05-04-2011 04:51 AM |