Software

Ask something
Question Locked

Excel

0 helpful
3 replies

by catfox65

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

3 replies

by sven2157

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

by dogknees

=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,...

This discussion is closed to new replies.