Microsoft Office Tutorials and References
In Depth Information
The HLOOKUP function
looks up the column
heading of a table
array and indexes the
number of rows that
follow as specified.
Index row number
Ta b l e array
HYPERLINK creates a shortcut to jump to a document stored on a network ser ver.
The HYPERLINK function can be used for several applications. For example, if you have a
workbook that contains 50 or 60 worksheets, you might want to create a main page and call out all
the pages on one page with hyperlinks to their respective pages. Take a look at the workbooks
on the CD accompanying this topic for examples. They are all set up with a main page and
hyperlinks to the respective pages. You can create a hyperlink to specific cells or ranges on a
specific sheet in the current workbook, to another external file, or even to a Web address.
There are a couple of ways to do this. One is from the Insert menu, choose Hyperlink. The
second way is with the HYPERLINK formula. Notice the formula shown in Figure 9.4. For
example, =HYPERLINK(CHOOSE!B2) results in a jump to the CHOOSE page. Another way to use the
HYPERLINK function is with a Web address or another office document.
This is the file location or path to the document that will be
displayed as text. This can be UNC (the path on a ser ver called
the universal naming convention) or URL (the path on a intranet
site or the Internet called the Uniform Resource Locator).
This is the text or numeric value that is displayed in a cell, previously
called cell contents. The Friendly_Name is displayed in blue and is
underlined. If it is omitted, the cell displays the Link_Location as
the jump text.