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.