ExcelBanter - vlookups and hyperlinks

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - vlookups and hyperlinks (https://www.excelbanter.com/excel-discussion-misc-queries/43385-vlookups-hyperlinks.html)

lmolle

vlookups and hyperlinks

I want to be able to enter a specified code on sheet 1 and have it go to the
hyperlink I have for that code on another sheet where I have the codes and
hyperlinks listed in a table format.
--
roo143us

Dave Peterson

Something like

=hyperlink(vlookup(a1,sheet2!a:b,2,false))

might work for you.

lmolle wrote:

I want to be able to enter a specified code on sheet 1 and have it go to the
hyperlink I have for that code on another sheet where I have the codes and
hyperlinks listed in a table format.
--
roo143us

--

Dave Peterson

All times are GMT +1. The time now is 10:34 PM.