View Single Post
  #1   Report Post  
nastech
 
Posts: n/a
Default 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