Question

Locked

Excel

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.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

Clarifications

Collapse -
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

All Answers

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

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums