software

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)=quot;See
JURISDICTIONSquot;,HYPERLINK(quot;C:\EnergyCodes\FullJuris .xlsquot;,quot;See Energy
Codesquot;),VLOOKUP(E53,EnergyCalcs,2,FALSE))

Thanks!!

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

=IF(VLOOKUP(E53,EnergyCalcs,2,FALSE)=quot;See
JURISDICTIONSquot;,HYPERLINK(quot;[C:\EnergyCodes\FullJuris.xls]Energy!F10quot;,quot;See
Energy
Codesquot;),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