Home

#REF index match

%3CLINGO-SUB%20id%3D%22lingo-sub-972347%22%20slang%3D%22en-US%22%3E%23REF%20index%20match%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-972347%22%20slang%3D%22en-US%22%3E%3CP%3EUsing%20index%20match%20to%20pull%20data%20from%20one%20excel%20file%20to%20another.%20After%20I%20save%20it%20random%20%22%23REFs%22%20will%20pop%20up%20in%20the%20index%20and%20match%20formulas.%20Any%20ideas%20for%20how%20to%20fix%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-972347%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-973107%22%20slang%3D%22en-US%22%3ERE%3A%20%23REF%20index%20match%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-973107%22%20slang%3D%22en-US%22%3EPlease%20post%20the%20formula.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-977790%22%20slang%3D%22en-US%22%3ERe%3A%20%23REF%20index%20match%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-977790%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F438445%22%20target%3D%22_blank%22%3E%40WME_Intern%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20general%20it%20shall%20work%20if%20you%20correctly%20use%20references%20within%20the%20formulas.%20It%20shall%20look%20like%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DINDEX('C%3A%5Cmyfolder%5C%5BBook2.xlsx%5DSheet1'!%24A%3A%24A%2CMATCH(A1%2C'C%3A%5Cmyfolder%5C%5BBook2.xlsx%5DSheet1'!%24C%3A%24C%2C0))%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3Ewith%20closed%20second%20workbook.%3C%2FP%3E%3C%2FLINGO-BODY%3E
WME_Intern
Occasional Visitor

Using index match to pull data from one excel file to another. After I save it random "#REFs" will pop up in the index and match formulas. Any ideas for how to fix?

2 Replies
Please post the formula.

@WME_Intern 

In general it shall work if you correctly use references within the formulas. It shall look like

=INDEX('C:\myfolder\[Book2.xlsx]Sheet1'!$A:$A,MATCH(A1,'C:\myfolder\[Book2.xlsx]Sheet1'!$C:$C,0))

with closed second workbook.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
48 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies