Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-11-2018, 12:10 PM
abc3132 abc3132 is offline Searching among hyperlinks Windows 7 64bit Searching among hyperlinks Office 2007
Novice
Searching among hyperlinks
 
Join Date: Feb 2015
Posts: 24
abc3132 is on a distinguished road
Default 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
Attached Files
File Type: xlsx Newspapers.xlsx (8.9 KB, 12 views)
Reply With Quote
  #2  
Old 01-11-2018, 01:56 PM
NBVC's Avatar
NBVC NBVC is offline Searching among hyperlinks Windows 10 Searching among hyperlinks Office 2013
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

Since you used column B to create the "friendly" hyperlink name, why can't you search for the name in column B instead?
Reply With Quote
  #3  
Old 01-11-2018, 01:58 PM
abc3132 abc3132 is offline Searching among hyperlinks Windows 7 64bit Searching among hyperlinks Office 2007
Novice
Searching among hyperlinks
 
Join Date: Feb 2015
Posts: 24
abc3132 is on a distinguished road
Default

Simply because I want the name WITH the link
Reply With Quote
  #4  
Old 01-12-2018, 03:31 AM
deciog deciog is offline Searching among hyperlinks Windows 10 Searching among hyperlinks Office 2016
Novice
 
Join Date: Feb 2017
Posts: 6
deciog is on a distinguished road
Default

Check if this is the way you want it

Decio
Attached Files
File Type: xlsx Newspapers Decio.xlsx (9.4 KB, 12 views)
Reply With Quote
  #5  
Old 01-12-2018, 05:00 AM
abc3132 abc3132 is offline Searching among hyperlinks Windows 7 64bit Searching among hyperlinks Office 2007
Novice
Searching among hyperlinks
 
Join Date: Feb 2015
Posts: 24
abc3132 is on a distinguished road
Default

Thanks for your time...but i do not understand. It doesn´t look like ti twill solve the issue
Reply With Quote
  #6  
Old 01-15-2018, 06:03 AM
NBVC's Avatar
NBVC NBVC is offline Searching among hyperlinks Windows 10 Searching among hyperlinks Office 2013
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Searching among hyperlinks searching a range using a value in another cell derohanes Excel 7 05-11-2015 03:01 PM
Searching among hyperlinks Searching for Dupes Gef Excel 7 03-02-2015 12:48 PM
Searching among hyperlinks Searching hyperlinks PuddinPie Word 1 05-27-2011 02:02 AM
Searching among hyperlinks Backwards Searching Using a Formula OTPM Excel 5 05-17-2011 09:17 AM
Searching among hyperlinks effective searching mar999 Office 1 05-04-2011 04:51 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:22 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft