Hi,

I've data (words) in more than 100 rows, I have numbered each row. There are 10-15 columns in each row. I'm hyperlinking cells of all the cells of a row to its respective row number. For example, If there are 15 columns in row 1, I'm hyperlinking all the 15 columns (B1 to P1) to A1 whose value would be 1. Similarly for 15 columns in row2, I'm hyperlinking (B2 to P2) to A2 whose value is 2 and so on..

Now, I've put all the cells from column B to Column P into single column Q (more than 1,000). Through data sorting I've sorted them in an order (alphabetically increasing order). I want to know from which row is the data (word) in every cell of Column Q is coming from? Upon clicking individual cell I'm going to the row number in Column A but I want the original row number of the word in each cell of column Q as its row value value in column R. something like the value of R1 should be the retrieved value of the hyperlinked cell of Q1. Value of R2, hyperlinked value of Q2 and so on.


In short, if cell B1 (a word) is hyperlinked to cell A1 (a number). I want to have the hyperlinked value of B1 (which is A1) in cell C1.

Many thanks in advance.

Cheers,
Kokab