•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Referencing local file instead of on `disc or network
I have an XLOOKUP where Excel wants to add unnecessary reference such as:
=XLOOKUP(I64,'https://d.docs.live.net/[deleted]/Documents/[Membership 2026-04-18.xlsx]... or
=XLOOKUP(I64,'C:\Users\[deleted]\OneDrive\Documents\[Membership 2026-04-18.xlsx]... Since a fellow club member will be using this file on his computer, references to my OneDrive account or local structure can't be included in the formulas because hsi computer is different from mine.
All files will be in the same folder. I've tried to reference these files like this:
./[Membership 2026-04-18.xlsx] but Excel won't accept this.
This is what I want:
=XLOOKUP(I3,'[Membership 2026-04-18.xlsx]2026-04-18'!$C:$C,'[Membership 2026-04-18.xlsx]2026-04-18'!$A:$A) How do I make this file play nicely with other files in the same local folder?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#no-code spreadsheet solutions
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#rows.com
#financial modeling with spreadsheets
#XLOOKUP
#Excel
#OneDrive
#local file
#reference
#file path
#folder
#document
#membership
#formula
#computer
#structure
#data
#cell reference