Conditional Hyperlink based on cell content

[arif120]

I want to create a Hyperlink (macro) based on cell value Sheet1!A1, where Sheet1!A1 contained formula and is always numeric. This is noted that others Sheets like Sheet2, Sheet3, Sheet3 etc. are always hidden.

e.g. Sheet1!A1=2 Go To Sheet2,
Sheet1!A1=3 Go To Sheet3,
Sheet1!A1=4 Go To Sheet4, etc.

Please someone help me.

 

[GraH - Guido]

arif120, how is it supposed to work?

If the number 2 needs to bring you to "sheet2", 3 to "sheet3",... and so on, then those sheets may not be hidden, if you want to do this with a formula.

In case sheets can be unhidden all the time, try this formula:
=HYPERLINK("#Sheet"&C2&"!A1","Go To Sheet "&C2)

If you need to unhide/hide, you would require a macro.

 

[arif120]

Sir, I tried this formula with INDEX-MATCH but this is not working for hidden Sheet, That why i need a macro.
Please help me if you can.

 

[GraH - Guido]

Then you should have posted in the VBA forum, dear.
Question is, why those sheets need to be hidden?