Hi All,
Basically my formula is this Xlookup(A2,'Http:///example'!A$2:A$5000,'Http:///example'!b$2:b$5000)
A2 is on the main spreadsheet
The hyper link is another workbook. so basically retrieving data in relation to A2 referenced from another workbook.
Is there way way I can shorten that URL within forumla?. At the moment my formulas are quite long so looking shorten them.
many thanks,
Basically my formula is this Xlookup(A2,'Http:///example'!A$2:A$5000,'Http:///example'!b$2:b$5000)
A2 is on the main spreadsheet
The hyper link is another workbook. so basically retrieving data in relation to A2 referenced from another workbook.
Is there way way I can shorten that URL within forumla?. At the moment my formulas are quite long so looking shorten them.
many thanks,