| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink
I have the following formula in a cell, sometimes my answer will be "
exception " =IF(ISNA(VLOOKUP(J38,'2006 Monthly Sales'!$E$2:$Q$386,10,FALSE)),"",VLOOKUP(J38,'2006 Monthly Sales'!$E$2:$Q$386,10,FALSE)) If the answer is "exception" I want it to automatically go to the exception worksheet - How about a hyperlink to that sheet or is there another way? thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort excel spreadsheet with hyperlink | Excel Discussion (Misc queries) | |||
| Hyperlink function fails when using variable row number | Excel Worksheet Functions | |||
| answer to odd results when comparing hyperlink addresses | Links and Linking in Excel | |||
| Hyperlink won't open any other XLS file | Excel Discussion (Misc queries) | |||
| Using the Hyperlink Function and finding filenames | Excel Worksheet Functions | |||
Threaded Mode
