Hello, I have two worksheets, my intention is from the table in 'sheet2!' make aditional hyperlinks that could take me to the specific cell that has same TEXT. Note: the cells in 'sheet1!' having the same TEXT is not in column, but in row, so I need hyperlink formula that could locate me directly to that cell.
I attach an example what I want to do
question.xlsx
Bookmarks