Hyperlinks and Named Ranges

[Guest]

I have a formula that currently checks a state abbreviation against a table.
If a certain value is retreived, a hyperlink is shown. How can I have the
hyperlink go to a named location within a separate file, based on the state
abbreviation used in the VLOOKUP command??

=IF(VLOOKUP(E53,EnergyCalcs,2,FALSE)="See
JURISDICTIONS",HYPERLINK("C:\EnergyCodes\FullJuris.xls","See Energy
Codes"),VLOOKUP(E53,EnergyCalcs,2,FALSE))

Thanks!!

 

[Pete]

If you want the file to open with the cursor at cell F10 in sheet
"Energy", for example, you can amend your formula as follows:

=IF(VLOOKUP(E53,EnergyCalcs,2,FALSE)="See
JURISDICTIONS",HYPERLINK("[C:\EnergyCodes\FullJuris.xls]Energy!F10","See
Energy
Codes"),VLOOKUP(E53,EnergyCalcs,2,FALSE))

i.e. include the sheet name and cell in the path and put square
brackets around the file name.

Hope this helps.

Pete