By CatFox65 ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Request for Clarification

by Sven2157 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? ...


Collapse -

Try This

by dogknees 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,...

Related Discussions

Related Forums