Adding a "go to" to a formula? Possible

[BB38]

I am using the following formula to allow the user to input a name and receive output in the form of row number(s)

=TEXTJOIN(", ",,FILTER(ROW(Table2[Investor]),LEFT(Table2[Investor],LEN(F8))=F8))

is it possible to add a "go to" view function that then sends the viewer to the first row of the spreadsheet that the output cell provides?

 

[BB38]

I was able to make it work, just had to figure out where to put in the -10.

Solved!

=HYPERLINK("#"&CELL("address",INDEX(Table2[Investor],LEFT(G8, FIND(",",G8&",")-1)-10)),"Goto")

Thank you!

 

[Fluff]

A slightly safer way would be

=HYPERLINK("#"&CELL("address",INDEX(Table2[Investor],LEFT(G8, FIND(",",G8&",")-1)-ROW(Table2[[#Headers],[Investor]]))),"Goto")

That way if somebody inserts or deletes rows above the table, it should still work.

 

[BB38]

thank you!!

 

[Fluff]

You're welcome & thanks for the feedback.