Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Email hyperlink
Formulas return values--not formatting, not hyperlinks, not formulas.
I guess you're lucky that the values are really email addresses <vbg. "Tazzy via OfficeKB.com" wrote: Hi Dave, Just tried what you suggested and it wortks out fine - thanks. Using the full formula you suggested confirms that you rightly said that I did not need the =and(), so one for me to remember. It's just slightly annoying that the lookup doesn't return the email hyperlink exactly as it does on the original sheet thoug. Any idea why? Tazzy -- Message posted via http://www.officekb.com -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
email hyperlink | Excel Discussion (Misc queries) | |||
How to Hyperlink in an email? | Excel Discussion (Misc queries) | |||
Email via hyperlink | Excel Discussion (Misc queries) | |||
Excel Email Hyperlink Bug | Excel Discussion (Misc queries) | |||
email using hyperlink | Excel Worksheet Functions |