Combine Multiple Functions into the Same Formula in Excel

Stripped of its complications, the hyperlink function you want would look like this.

=HYPERLINK("#Blad1!E117","Totaal")

Observe that the function takes two string arguments, sparated by a comma. That means that you problem is with a string. Anything you feed to the function that isn't a string won't work. And if it's a string that isn't a valid address another kind of error will result. That's the case with your formula. 

Your string looks like this:-

"#Blad1!=CELL("contents",K33)"

If it could be dissected it would translate into "#Blad1!=E117" which isn't a valid address. Remove the equal sign and it might work. But it won't. That's because in
"#Blad1!CELL("contents",K33)" the function CELL("contents",K33) is passed as a string instead of being evaluated. What you want is to concatenate the sheet name with the evaluation of the CELL function. That would look as shown below.

"#Blad1!"&CELL("contents",K33)

If you embed this string as the first argument in your HYPERLINK function it will do what you intend. The function below will also work. It uses the INDIRECT function instead of CELL which is less commonly used and a little more elaborate.

=HYPERLINK("#Blad!"&INDIRECT("K33"),"Total")

Hi F1reP0wer,

I too use Excel 2007. Your formula is almost perfect except for a couple of syntax errors. Even one typo and the formula will barf.

Your original formula looks like this:

=HYPERLINK("#Blad1!=CELL("contents",K33)","Totaal")

Change your HYPERLINK formula to the following (it works for me)

=HYPERLINK("#Blad1!" & CELL("contents",K33),"Totaal")

Note: unless intentional, it appears that there is a spelling mistake in the 'friendly name' - did you mean it to be Total?

Hope this helps.

Cheers   ;-}