Software·43,881 discussions

Excel

Locked

I am trying to hyperlink with an if then formula:

If B2=Letter Name1 then hyperlink to sheet1 A1, if B2=Letter Name2 then hyperlink sheet2 A1, if B3=Letter Name3 then hyperlink to sheet3 A1 and so on.

I am in Microsoft 2010. Ugh this one is stumping me so any help would be appreciated.

Topic

Clarifications

In reply to Excel

Clarifications

Request for Clarification

In reply to Clarifications

Could you elaborate a bit more? There is not really enough detail about what it is that you are looking for in the end result. Also, could it not be working because you reference B2 twice? Or was that just a typo here? …

Sven2157

Try This

In reply to Excel

=if(b2=”Letter Name 1″,hyperlink(“#Sheet1!A1”),hyperlink(“#Sheet2!A1”))

If you have the number of the sheet in a cell, say B1, and put the following in B2, you can make the link go to the sheet with the same number in it’s name.

=hyperlink(“#Sheet” & B1 & “!A1”)
If B1 is “1”, the link goes to Sheet1, if B1 is “5”, the link will take you to Sheet5,…

[Author]

Replies