H
Heyna
Hi;
I've got Formulas that I'm too lost to do anything with.
Basically, I'm getting hyperlinks to show in cells that are motivate
from Vlookup lists that are connected to validation cells.
The formulas I've been using work for what I want them to do: you pic
a Job from a validated cell( B47) then pick a client (C47), and the
the formulas pick thier fax and email from a sorted lookup list.
But, not everyone has a valid fax number, or email. However, the way
made up my formula to work, it will put the words "email" and "fax" i
the cells whether there is any information in the proper lookup column
Here's an example of my formula- what I'd like to do is add an =IF t
the formula that will keep the cell blank if there is no fax number o
email address (value in the column for the lookup), but I am so burne
and lost I'm almost ready to allow the #N/A's to rule the day..
almost.
Here's an example of the formula:
=IF(C47="","",HYPERLINK(CONCATENATE("MailTo:",VLOOKUP(C47,SubNumber,3,0)),"Sen
Mail"))
Many thanks to anyone who can direct me where my @#$% =If should go, o
any easier answers...
Scot
I've got Formulas that I'm too lost to do anything with.
Basically, I'm getting hyperlinks to show in cells that are motivate
from Vlookup lists that are connected to validation cells.
The formulas I've been using work for what I want them to do: you pic
a Job from a validated cell( B47) then pick a client (C47), and the
the formulas pick thier fax and email from a sorted lookup list.
But, not everyone has a valid fax number, or email. However, the way
made up my formula to work, it will put the words "email" and "fax" i
the cells whether there is any information in the proper lookup column
Here's an example of my formula- what I'd like to do is add an =IF t
the formula that will keep the cell blank if there is no fax number o
email address (value in the column for the lookup), but I am so burne
and lost I'm almost ready to allow the #N/A's to rule the day..
almost.
Here's an example of the formula:
=IF(C47="","",HYPERLINK(CONCATENATE("MailTo:",VLOOKUP(C47,SubNumber,3,0)),"Sen
Mail"))
Many thanks to anyone who can direct me where my @#$% =If should go, o
any easier answers...
Scot