Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hyperlink Question
With a hyperlink, is it possible to find a cell in a column, for the first
instance of a word starting with a letter, say "a" with something like?: =HYPERLINK("[file.xls]sheet!(LEFT($A:$A,1)=$B$5)","goto") where B5 has the letter A entered. Selecting a column seems to work with: =HYPERLINK("[file.xls]sheet!A:A","goto") Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink Question | Excel Discussion (Misc queries) | |||
hyperlink question | Excel Discussion (Misc queries) | |||
excel Hyperlink question | Excel Discussion (Misc queries) | |||
hyperlink question | Excel Worksheet Functions | |||
Hyperlink Question | Excel Discussion (Misc queries) |