Hyperlink with a conditional?

[meanpplsuk]

Probably something terribly simple, just haven't run across it and I am a complete newbie on this so excuse my terminology. I am trying to create a hyperlink that:

Creates a link depending on what is in a cell to another worksheet
Ex: IF G1 = "Apple" THEN RETURN LINK for Apple worksheet.

[amy_d2]

Hi & welcome to the forum,

a small sample of your worksheet would be more advisable to answer your question