Shorten Link within XlookUp

Yugo101

New Member
Joined
Jun 12, 2017
Messages
41
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,
 
I don't know of any way you can shorten the URL but it may help to use the LET statement eg.
Rich (BB code):
=LET(extRng,'Http:///[example]example'!A$2:B$5000,
     XLOOKUP(A2,INDEX(extRng,,1),INDEX(extRng,,2)))
 
Upvote 0
Given the particular example you could also use VLOOKUP instead of XLOOKUP and then you would only need the link path once
Excel Formula:
VLOOKUP(A2,'Http:///example'!A$2:B$5000,2,0)

BTW, I suggest that you update your forum profile (click your user name at the top right of the forum, then ‘Account details’) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)
 
Upvote 0

Forum statistics

Threads
1,226,772
Messages
6,192,928
Members
453,767
Latest member
922aloose

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top