Dynamic Hyperlink Based on Cell value

[HolyLemon]

Is there a way to create a hyperlink that is dynamically linked to a cell value, in which the cell value points to a cell reference within a worksheet, and that when the value is changed can point to a different cell reference.

I am looking for a way to create a hyperlink without using Macros. I have a column (P) in a worksheet called Annual Review. Everything in column P is an automaticly generated Row number referencing the customers details on the other worksheet "MGP4" So if in P2 on "Annual Review" it says 43. I know that the Customers Details can be found on line 43 on worksheet "MGP4".

Im looking for a way to make it a hyperlink but as a formula so i can copy it down, there are several thousand entries on both worksheets.

If anyone can help me or has any questions i would be very grateful.

Thanks,
Harry

 

[Andrew Poulsom]

Try:

=HYPERLINK("#MGP4!A"&P2)

You can add a second argument for the text to display if you want.

 

[HolyLemon]

That is outstanding! Thank you very much!!!

 

[smiley3141]

Thank you. This was exactly what I wanted to know and your solution worked perfectly!

 

[Dhira]

Try:

=HYPERLINK("#MGP4!A"&P2)

You can add a second argument for the text to display if you want.

This works brilliantly. But how do you add a second arguement for the text to display?

 

[VoG]

Try

=HYPERLINK("#MGP4!A"&P2,"Your text")

 

[crook_101]

Hi,

As Andrew is off-line, i have taken the liberty of responding

This is what you are after??

Cheers,
Ian

Excel Workbook
	B
5	nice name
Sheet3

 

[gougouna]

Thank You all for the answer and the question too

 

[MorriSiege]

Hi

Would this work with a formula embedded also?

one would be an =offset and another is an =if formula.

Thanks
Richard

 

[vikas29]

Try:

=HYPERLINK("#MGP4!A"&P2)

You can add a second argument for the text to display if you want.

Question on the same line. I have two sheets. Column A of sheet 1 is having n entries and Column B of Sheet 2 is having same entries but not in the same order. I need to link those entries. How to do that?

Thanks in advance.