Maybe there's a difference in versions.

I use xl2003.

KarenF wrote:

Hi Dave,

Yes, using your example, I saw that too.

The funny thing is that if I copy and paste special the value returned by
the formula, this is clickable and starts a new addressed e-mail message.
However, the formula result still does not!

Odd but true. I'll take a look around and see if I have any capabilities
switched off.

Thanks for your help Dave.

Take care,

Karen.

"Dave Peterson" wrote:

It worked ok for me.

What do you see in the cell--not the formula, but the value?

I saw:


(or something like that.)

KarenF wrote:

Hi Dave,

Thanks for your reply.

Not sure if my first reply to this went, so apologies if this is the second
time I've replied here.

When I hover over the cell, the mouse pointer becomes the gloved hand, but
when I click the cell it doesn't go anywhere. Not even if I press Control
and click. Normal hyperlinks work. Have I got my formula correct? It is
below:

=IF(ISBLANK($A6),"",IF(ISBLANK(VLOOKUP($A6,applica nt,14,FALSE)),"",hyperlink("mailto:"&VLOOKUP($A6,a pplicant,14,FALSE))))

As for how it looks, I don't mind how pretty it is, as long as it works!

Any further ideas?

Thanks Dave.

Karen.

"Dave Peterson" wrote:

Are you sure it's not a hyperlink?

When I did this, it didn't look pretty, but I could click on that cell and an
email message would be started.

If the looks are important, you could format the cell:
select the cell/range
format|Style|hyperlink
(from the top dropdown list)



KarenF wrote:

Hi Dave,

This is the formula that is returning the non-hyperlink value

=IF(ISBLANK($A6),"",IF(ISBLANK(VLOOKUP($A6,applica nt,14,FALSE)),"",VLOOKUP($A6,applicant,14,FALSE)))

Now I'm going to try and insert your hyperlink functions

=IF(ISBLANK($A6),"",IF(ISBLANK(VLOOKUP($A6,applica nt,14,FALSE)),"",hyperlink("mailto:" & VLOOKUP($A6,applicant,14,FALSE))))

What do you think? Am I getting close?

This gives me the full mailto:emailaddress result, but is not hyperlinking.
I think I must be missing something.

Any ideas?

Thanks Dave,

Karen.

"Dave Peterson" wrote:

Formulas won't return the links, but depending on what you're returning, maybe
you could use that to build the hyperlink:

=hyperlink(vlookup(...))
or
=hyperlink("mailto:" & vlookup(...))

But that value returned has to be the link--not just a nice displayed
name/string.





KarenF wrote:

Hi,

I am using VLookups to populate several workbooks with data from a master
workbook. My current problem is that on the master book, there are e-mail
addresses which are currently hyperlinked. When I use the VLookup to
populate my cells with e-mail addresses, is there any way that I can keep the
hyperlinked properties of the data?

Many thanks,

Karen

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson