How to make a fill-in Cell remain Blank when using Vlookup in a complex formula...

[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

 

[Aladin Akyurek]

An excellent occasion for using two cells in order to pick up the right
results from a Vlookup formula:

http://makeashorterlink.com/?H28622847