So, the thing is: I have an excel with two sheets. In sheet 1 I have, let's say, 4000 senteces (arranged in some defined order).
In sheet 2 I have those senteces on a single column randomnly arranged
.
On the column right to those sentences from sheet 2 I write the equivalent sentences in my native language and I don't know how to make all those senteces from Sheet 2, Column 1 as linked with the identical cell value from Sheet 1. I will attach an exemple so I can explain this better.
.
Can I do something about it? I don't know very much about VBA or excel commands so any help will be appreciated.
If I didn't explain my issue in a way so you can understand, please let me know.
Thank you!
CodePudding user response：
In your Sheet2, you may use HYPERLINK combined with MATCH. As example:
My formula in Sheet2, cell B1 is:
=HYPERLINK("#Sheet1!C"&MATCH(A1;Sheet1!C:C;0))
If I click in that cell, it takes me to Sheet1, cell C9, where my target_value has been located.
Source: 
As you can see, each value searched is on a different column. Now formula is:
=HYPERLINK(IFERROR("#Sheet1!C"&MATCH(A1;Sheet1!C:C;0);IFERROR("#Sheet1!D"&MATCH(A1;Sheet1!D:D;0);IFERROR("#Sheet1!E"&MATCH(A1;Sheet1!E:E;0);IFERROR("#Sheet1!F"&MATCH(A1;Sheet1!F:F;0);"#Sheet1!G"&MATCH(A1;Sheet1!G:G;0))))))
Anyways, I've uploaded a sample to Gdrive in case you want to check the formulas: