Hi,
I was wondering if there was a way to use the cell F4 or the hyperlink in cell F4 in the Xlookup formula, instead of manually linking the lookup array.
I would like to have it so that when a link is generated in column F, the Xlookup formula in column B automatically references the data in the link in column F.
Is there any way to do this without VBA too?
Thank you in advance.
I was wondering if there was a way to use the cell F4 or the hyperlink in cell F4 in the Xlookup formula, instead of manually linking the lookup array.
I would like to have it so that when a link is generated in column F, the Xlookup formula in column B automatically references the data in the link in column F.
Is there any way to do this without VBA too?
Thank you in advance.