How to shorten path in formulas?

Hi!

I have to insert a several formulas (Index - match) on the sheet, which finds the data in another workbook, like the one in the example below:

Please Login or Register  to view this content.

.

It works fine, except that the path to another workbook is rather long, so I'd like to shorten it.

I'd like to do something like:

Please Login or Register  to view this content.

but this isn't working correctly because it keeps opening a file dialog box and asking to update values for

Please Login or Register  to view this content.

What is the right way to do it?

I'm using Excel for Microsoft 365 for small businesses.

The last thing you showed

Please Login or Register  to view this content.

doesn't make sense to me. I don't know how you are using that.

If you just want to shorten the code (it won't shorten what you see in the cell) try this:

Please Login or Register  to view this content.

(removed misread)

You are very welcome and thanks for the rep!