Home

Reference in the OFFSET function

%3CLINGO-SUB%20id%3D%22lingo-sub-549146%22%20slang%3D%22en-US%22%3EReference%20in%20the%20OFFSET%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-549146%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20am%20just%20learning%20how%20to%20use%20pivot%20tables.%20In%20an%20example%20I%20have%20found%20the%20formula%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%22%3DOFFSET(Summary%5B%40%5BS.%20No.%5D%5D%2C%24O%242%2C0)%22%2C%20and%20Excell%20does%20not%20recognize%20it%20and%20I%20can't%20find%20%22Summary%22%20beetwen%20the%20functions.%20What%20does%20it%20means%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-549146%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-549292%22%20slang%3D%22en-US%22%3ERe%3A%20Reference%20in%20the%20OFFSET%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-549292%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F338309%22%20target%3D%22_blank%22%3E%40jabrito_56%3C%2FA%3E%26nbsp%3B%2C%20that%20is%20structured%20reference.%20Summary%20is%20the%20name%20of%20the%20Excel%20Table%2C%20and%20S.No.%20is%20column%20name.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-555890%22%20slang%3D%22en-US%22%3ERe%3A%20Reference%20in%20the%20OFFSET%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-555890%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%20I%20got%20it!.%3C%2FP%3E%3C%2FLINGO-BODY%3E
jabrito_56
New Contributor

Hello,

I am just learning how to use pivot tables. In an example I have found the formula: 

"=OFFSET(Summary[@[S. No.]],$O$2,0)", and Excell does not recognize it and I can't find "Summary" beetwen the functions. What does it means? 

2 Replies

@jabrito_56 , that is structured reference. Summary is the name of the Excel Table, and S.No. is column name. 

 @Sergei Baklan 

Thank you, I got it!.