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!!