XLOOKUP or VLOOKUP to return a hyperlink

[thewiseguy]

Hi all,

Is it possible to have a table containing webpages, and then an XLOOKUP or VLOOKUP formula to bring those values back as hyperlinks?
Currently, the value in O2 is NOT a hyperlink. I tried adding the HYPERLINK function to the formula but im getting a trusted source error?

v2023.8.xlsm
	I	J
2	Shipper	URL
3	A. Duie Pyle	www.aduiepyle.com
4	Daylight	dylt.com
5	EDI Express	ediexpressinc.com
6	Estes
7	FedEx
8	N/a
9	New Penn
10	Old Dominion
11	Pickup
12	R+L Carriers
13	UPS
Project (validations)

v2023.8.xlsm
	G				K	L	M	N	O
1	Quantity				PO #	Qty Ordered	Shipper 1	Tracking 1	Link
2							A. Duie Pyle		www.aduiepyle.com
Full BOM (prd.mat.ren.)

Cell Formulas
Range	Formula
G2	G2	=H2&""&I2&""&J2
O2	O2	=(XLOOKUP(M2,TblShipperFull[Shipper],TblShipperFull[URL],""))

 

[Joe4]

You need to wrap your formula in the HYPERLINK function, if you want what is returned to also be a hyperlink, i.e.

=HYPERLINK(XLOOKUP(M2,TblShipperFull[Shipper],TblShipperFull[URL],""))

If you still get a "Trusted Source" message, that probably has to do with your company's security policy, saying it doesn't trust the web site.

 

[thewiseguy]

You need to wrap your formula in the HYPERLINK function, if you want what is returned to also be a hyperlink, i.e.

=HYPERLINK(XLOOKUP(M2,TblShipperFull[Shipper],TblShipperFull[URL],""))

If you still get a "Trusted Source" message, that probably has to do with your company's security policy, saying it doesn't trust the web site.

i was actually able to get it to work. I needed to add: https://

thanks