Index Matching, pulling through a link query

[MattExcelLearner]

Hi all

I have a spreadsheet which uses index matching to pull through information from tab 2 into tab 1.

Information from tab 2 comes from SharePoint.

It all works and the index match pulls though the words but not as a link.

Is there away I can get this pulling through as a link?

Saves having to go to tab 2 to open the link. Haha

Thanks in advance.

[MattExcelLearner]

Getting closer:

=HYPERLINK(INDEX(owssvrb!$B:$B,MATCH(C4,owssvrb!$A:$A,FALSE)))&""

Looks like a link now just doesn't open, I changed the link to www.google.co.uk to test and it said cant open the specified file

[MattExcelLearner]

someone else may have worked it out, but I can't work out how to apply there formula to mine.

There example attached.

[MattExcelLearner]

I'm starting to think it's really not possible

I have seen from google other forums saying its not.

[Glenn Kennedy]

Where did you find that example?

[Glenn Kennedy]

I assume that you don't want to use VBA, in in column E of the attachgment at Post 3? Correct??

[MattExcelLearner]

I believe it was here: http://www.helpwithhowto.com/excel-f...t-a-hyperlink/


Under workbook example

[MattExcelLearner]

I have not used VBA before, so wouldn't know where to start.

[Glenn Kennedy]

I'm hopeless with it myself. But is there any reason why it CAN'T be used (company policy, etc)?

[Glenn Kennedy]

Open, enabling macros...

[MattExcelLearner]

Wow that actually works but, I even tried this formula but it didn't work for me yesterday. I must of made an error somewhere, so I'm going to cross reference.

=HYPERLINK(HLink(INDEX(owssvrb!$B$2:$B$36,MATCH($C4,owssvrb!$A$2:$A$36))),INDEX(owssvrb!$B$2:$B$36,MATCH($C4,owssvrb!$A$2:$A$36,0)))

Many thanks for taking a look at this.

Regards

[Glenn Kennedy]

You probably didn't copy the code across into a module and save as an .xlsm...

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

[MattExcelLearner]

annoyingly I can't make it work in a live version.

[Glenn Kennedy]

You mustn't have understood my comments in Post 12...

Please Login or Register  to view this content.

How to install your new code
Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Press Alt+F11 to open the Visual Basic Editor
Choose Insert > Module
Edit > Paste the macro into the module that appeared
Close the VBEditor
Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)