Hyperlink in IF statement
Posted by Maarten on January 20, 2002 7:58 AM
IF($F$34="Gebouw verbeekstraat";HYPERLINK(Hoofdscherm!;"GO");"NO DATA")
With this formula, I want to go to another worksheet in Excel called Hoofdscherm. I want Excel to give the cell the name GO. So IF someone select in the list the name "Gebouw verbeekstraat" and he pushes the button GO he automatically go to the worksheet "Hoofdscherm"
What do I do wrong?
Is there a direct way from the list to other worksheets, I tried a list of hyperlinks but it will not work.