Hyperlink
Well what are you looking to do in the exception tab? That would determine
what you would enter for it.
--
Brevity is the soul of wit.
"Wanna Learn" wrote:
Dave Thanks for your prompt reply
True Brevity is the soul of wit but not today .
Yes, "exception" is the value returned
Not sure what I have to add to my existing formula to make it work Please
clarify again thanks
"Dave F" wrote:
Where do you get "exception"? Is that a value returned in your VLOOKUP?
If so, then you would do something like
=IF(VLOOKUP([arguments])="exception",[Do what you want to do in the exception
tab],[Enter your ELSE clause here]).
Hope that helps.
Dave
--
Brevity is the soul of wit.
"Wanna Learn" wrote:
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
|