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

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

Hi Dave,

This looks good. Yes, it is the link and the mailto suggestion looks great.

Thanks very much again.

Take care,

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

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

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

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

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