Combine Hyperlink formula with Index and Match possible?
Posted by Connie on July 13, 2001 7:53 AM
Thanks to Aladin, I have a formula in one cell that performs a lookup, and returns a name (it's a name drawn from having a "Top 15" score) and I'm wondering if it would be possible to add a hyperlink function to this formula, to where I could click on the name and be taken to a separate document to read more about that person. The tricky thing is, as scores change, so will the names of the people, so if Jones is the top scorer today (in cell A1), he may be replaced by someone else tomorrow who gets a higher score. The way this was being treated was to have a hyperlink formula in an adjacent cell, but my boss thinks it could all be combined into one formula, to where I could click on the name Jones and be taken to his document. I can't imagine how this could be done. Any thoughts?
Here is the formula that looks up the Top 15 scorers:
=IF(ROW()-1<=15,INDEX('ALL NAMES'!A$6:A$26,MATCH(ROW()-1,'ALL NAMES'!$J$6:$J$26,0)),"")
and here is the hyperlink formula that currently sits in an adjacent cell:
Does anyone think these could be combined into one cell?