Help with Hyperlink Function (possibly dynamic?)

Hi All,

I am looking for help with a hyperlink function. I am currently working in a workbook with tabs "a" and "b". Tab a has about 4000 rows of information. In tab b I have numbers in column a that reference items in column b of tab a. In column B of tab B I want to create a hyperlink that will link to the corresponding number in column b of Tab A (kind of like a vlookup). I am mainly using this for ease of use and I dont have any clue how to do this.

I appreciate any help you can offer!

Thanks

In B1 of sheet B you can use this formula:

=HYPERLINK("#a!R"&MATCH(A1,a!B:B,0)&"C1","jump")

The word "jump" will appear in the cell and if you click on this it will take you to the corresponding row in sheet A. Copy the formula down as required.

Hope this helps.

Pete

Thanks pete! I will try that out. What does the R do in your equation?

The formula uses R1C1 notation - R stands for Row, and it is followed by the row number where the match is found, and the C1 indicates column A. You might want to change this to C2 if you want the cursor to jump to column B.

Hope this helps.

Pete