H
Heyna
Hi All;
I have a Spreadsheet that uses validation cells to create a pull dow
menu of various clients/subcontractors for workers to choose from
There are cells adjacent to the validation cells that are motivated b
a Lookup table (Vlookup) and one column holds phone numbers, the othe
email addresses. They fill in with the correct email and phone for th
validation choice. I can create hyperlinks so that the person's emai
opens Oulook's email send program- which is cool. A choice i
hyperlinks is to show what text is visible in the cell: I wish to hav
the word "email" show in the hyperlinked cell, as this is easily show
in the space provided (as opposed to (e-mail address removed)).
My problem is this: not everyone has an email address. So, can I onl
have a hyperlink show in a column that is devoted to email addresses i
there is a valid email address in that lookup column?
As of now, (in the lookup column designated for email) I have "N/A
typed into cells without an email address in them, and an IF formula t
make the spreadsheet cell register blank
=IF(c5="","",VLOOKUP(k5,email,2,0)) I would like to set up a way t
have the word "email"- as a hyperlink- show if there is a valid email
and remain blank or say "N/A", and have no hyperlink appear. Can thi
be done?
Many thanks,
Scot
I have a Spreadsheet that uses validation cells to create a pull dow
menu of various clients/subcontractors for workers to choose from
There are cells adjacent to the validation cells that are motivated b
a Lookup table (Vlookup) and one column holds phone numbers, the othe
email addresses. They fill in with the correct email and phone for th
validation choice. I can create hyperlinks so that the person's emai
opens Oulook's email send program- which is cool. A choice i
hyperlinks is to show what text is visible in the cell: I wish to hav
the word "email" show in the hyperlinked cell, as this is easily show
in the space provided (as opposed to (e-mail address removed)).
My problem is this: not everyone has an email address. So, can I onl
have a hyperlink show in a column that is devoted to email addresses i
there is a valid email address in that lookup column?
As of now, (in the lookup column designated for email) I have "N/A
typed into cells without an email address in them, and an IF formula t
make the spreadsheet cell register blank
=IF(c5="","",VLOOKUP(k5,email,2,0)) I would like to set up a way t
have the word "email"- as a hyperlink- show if there is a valid email
and remain blank or say "N/A", and have no hyperlink appear. Can thi
be done?
Many thanks,
Scot