Using HYPERLINK Function in array formula

[james.j.andersen]

I've spent a good part of the day working on a few pretty complex
array formulas. I'd now like to add one that will create an array of
hyperlinks. I thought I could do something equivalent to:
=HYPERLINK({"http://google.com","http://yahoo.com","http://
microsoft.com"}, {"google","yahoo","microsoft"})

....but I just end up with an array filled with google links...

Anyone have any ideas?
Thanks,
James

 

[Héctor Miguel]

hi, James !

I've spent a good part of the day working on a few pretty complex array formulas.
I'd now like to add one that will create an array of hyperlinks.
I thought I could do something equivalent to:
=HYPERLINK({"http://google.com","http://yahoo.com","http://microsoft.com"},{"google","yahoo","microsoft"})
...but I just end up with an array filled with google links...

not an array formulae, but you need to point/index which address will be hyperlinked (i.e.)

[A1] =hyperlink(index({http://google.com";"http://yahoo.com;"http://microsoft.com"},row()),index({"google";"yahoo";"microsoft"},row()))

copy-down n_links

hth,
hector.

 

[james.j.andersen]

hi, James !

I've spent a good part of the day working on a few pretty complex arrayformulas.
I'd now like to add one that will create an array of hyperlinks.
I thought I could do something equivalent to:
=HYPERLINK({"http://google.com","http://yahoo.com","http://microsoft.com"},{"google","yahoo","microsoft"})
...but I just end up with an array filled with google links...

not an array formulae, but you need to point/index which address will be hyperlinked (i.e.)

[A1] =hyperlink(index({http://google.com";"http://yahoo.com;"http://microsoft.com"},row()),index({"google";"yahoo";"microsoft"},row()))

copy-down n_links

hth,
hector.

Thanks Hector!

 

[Héctor Miguel]

hi, James !

Thanks ...

thanks to you, I really appreciate your feed-back

regards,
hector.

I've spent a good part of the day working on a few pretty complex array formulas.
I'd now like to add one that will create an array of hyperlinks.
I thought I could do something equivalent to:
=HYPERLINK({"http://google.com","http://yahoo.com","http://microsoft.com"},{"google","yahoo","microsoft"})
...but I just end up with an array filled with google links...

not an array formulae, but you need to point/index which address will be hyperlinked (i.e.)
[A1] =hyperlink(index({http://google.com";"http://yahoo.com;"http://microsoft.com"},row()),index({"google";"yahoo";"microsoft"},row()))
copy-down n_links