Hello and thank you in advance for any help.
I'm looking to have VLOOKUP return a hyperlink, but one which is a reference within the workbook, rather than a URL. Can't find a format for writing the hyperlink to begin with that Vlookup can then return as working. Explanation of the below representation is that the first sheet is a list of questions and answers. The Answer locations is where I want the links to bring the user. In the second sheet, the Question columns would be blank until someone fills in which Question they are looking for. The Vlookup would then populate the Answer column with the link back to that location of the first sheet. What I had used, which works for URLs but not this, is =HYPERLINK(VLOOKUP(Question,Questions:Answers,2,0). Any suggestions?
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Question 1[/TD]
[TD]Answer 1[/TD]
[/TR]
[TR]
[TD]Question 2[/TD]
[TD]Answer 2
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Question 1[/TD]
[TD]Link to Answer 1[/TD]
[/TR]
[TR]
[TD]Question 2[/TD]
[TD]Link to Answer [/TD]
[/TR]
</tbody>[/TABLE]
I'm looking to have VLOOKUP return a hyperlink, but one which is a reference within the workbook, rather than a URL. Can't find a format for writing the hyperlink to begin with that Vlookup can then return as working. Explanation of the below representation is that the first sheet is a list of questions and answers. The Answer locations is where I want the links to bring the user. In the second sheet, the Question columns would be blank until someone fills in which Question they are looking for. The Vlookup would then populate the Answer column with the link back to that location of the first sheet. What I had used, which works for URLs but not this, is =HYPERLINK(VLOOKUP(Question,Questions:Answers,2,0). Any suggestions?
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Question 1[/TD]
[TD]Answer 1[/TD]
[/TR]
[TR]
[TD]Question 2[/TD]
[TD]Answer 2
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Question 1[/TD]
[TD]Link to Answer 1[/TD]
[/TR]
[TR]
[TD]Question 2[/TD]
[TD]Link to Answer [/TD]
[/TR]
</tbody>[/TABLE]