hidden @ sign in formula, not related to Tables

%3CLINGO-SUB%20id%3D%22lingo-sub-2263574%22%20slang%3D%22en-US%22%3Ehidden%20%40%20sign%20in%20formula%2C%20not%20related%20to%20Tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2263574%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20am%20trying%20to%20help%20a%20colleague%20who%20seems%20to%20have%20some%20weird%20setting%20in%20his%20excel.%20When%20he%20uses%20INDEX%20%26amp%3B%20MATCH%20instead%20of%20vlookup%20the%20formula%20looks%20correct%20but%20returns%20an%20error%20until%20he%20presses%20control%20shift%20enter%2C%20making%20it%20an%20array%20-%20then%20it%20works.%20When%20he%20sends%20the%20file%20to%20me%20and%20I%20open%20it%20on%20my%20computer%2C%20I%20see%20that%20he%20has%26nbsp%3B%40%26nbsp%3B%20signs%20(see%20below)%20in%20front%20of%20the%20sheet%20he%20is%20referencing%20(these%26nbsp%3B%40%20do%20NOT%20show%20up%20in%20his%20excel).%20When%20I%20remove%20the%26nbsp%3B%40%26nbsp%3B%20on%20my%20computer%2C%20it%20works%20again.%20I%20thought%26nbsp%3B%40%26nbsp%3B%20was%20normally%20to%20do%20with%20tables%20but%20he%20is%20not%20using%20any%20tables%20either...can%20someone%20help%3F%20TIA!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DINDEX(Sheet2!D%3AD%3BMATCH('Bought%20articles'!C2%26amp%3B'Bought%20articles'!A2%3B%40Sheet2!C%3AC%26amp%3B%40Sheet2!A%3AA%3B0))%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2263574%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi, I am trying to help a colleague who seems to have some weird setting in his excel. When he uses INDEX & MATCH instead of vlookup the formula looks correct but returns an error until he presses control shift enter, making it an array - then it works. When he sends the file to me and I open it on my computer, I see that he has @  signs (see below) in front of the sheet he is referencing (these @ do NOT show up in his excel). When I remove the @  on my computer, it works again. I thought @  was normally to do with tables but he is not using any tables either...can someone help? TIA!

 

=INDEX(Sheet2!D:D;MATCH('Bought articles'!C2&'Bought articles'!A2;@Sheet2!C:C&@Sheet2!A:A;0))

1 Reply