|You have both cells A1 & A2 in your formulas as posted.|
In the above formula, the jump to sheet number, must be in cell A1,
and it will link you to Sheet Number, Cell A2.
I have no idea what is in cell A2, so I don't know what it
will display as a friendly name.
B2 rather it is showing #Value! Error
Don't know what your doing in cell B2.
Have no idea why you would be getting a #VALUE error:
In Microsoft Excel, when you perform a mathematical operation on cells that contain text and values, you may receive a #VALUE! error.
What else is going on, are you calculating the sheet number?
Are the cells formatted as TEXT?
Open a brand new workbook and try it on a clean sheet, perhaps you have
a corrupted worksheet.
In cell A1 enter the sheet number you wish to jump to.
In cell B1 use one of the formulas.