Hyperlink Help

[GregDCBA]

Hyperlink Help

I am trying to populate a working Hyperlink from a list on a separate sheet using the XLOOKUP and HYPERLINK functions. The formula I am using is

=HYPERLINK(XLOOKUP($B8,'Course List'!$B$2:$B$10,'Course List'!$D$2:$D$10))

Everything populates OK, even as a hyperlink. However when clicking on the Hyperlink it does not work, it seems like it is referencing the actual cell on the “Course List” sheet and not the true web address.

I know it can be done, but I can not find anywhere showing a similar formula I need to use.

Is there a Guru out there that can show me the formula I need to use to make this work

Thanks

 

[myall_blues]

Although the address to, for example, www.microsoft.com on the 'Course list' tab works if you click it, Excel is making the assumption there is an https:\\ in front to make it work. The =HYPERLINK formula, on the other hand, is just transferring the text from D8 without the https:\\, so you need to add it.
You can do that in one of two places

• On the course list page: https:\\www.microsoft.com
• As part of the formula: =HYPERLINK(XLOOKUP(B8,'Course List'!B2:B10,"https:\\" & 'Course List'!D2:D10))