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