HYPERLINK using nested IF

[PNY80]

Hello - I'm trying to write a formula to hyperlink a cell based on the value of another. So far I have this:

=IF(A14=5, HYPERLINK(sheet1!A1, "friendly name"), HYPERLINK(sheet2!A1,"friendly name"))

But am getting a "Reference is not valid." error and I can't figure it out what I'm doing wrong. Please help!

Thank you!

 

[timfritsch]

Try this:

http://www.mrexcel.com/forum/excel-questions/213819-hyperlink-nested-if-function-print.html


Tim

 

[PNY80]

Thanks Tim! But I seem to be getting the same error again, even after making the changes in my formula. I'm not sure what's wrong...

 

[PNY80]

I've started a new sheet and it seems to be working now! thanks so much!