Question formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1538894%22%20slang%3D%22en-US%22%3EQuestion%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1538894%22%20slang%3D%22en-US%22%3EI%E2%80%99m%20working%20on%20a%20spreadsheet%20and%20getting%20trouble%20to%20understand%20one%20formula.%3CBR%20%2F%3E%3CBR%20%2F%3EROUNDUP(VLOOKUP(%24D%247%2C'SALES'!%24A%3A%24BH%2CCOLUMN(G%2410)%2B24%2CFALSE)%2C0)%3CBR%20%2F%3EI%20don%E2%80%99t%20understand%20this%20%2B24.%20Can%20someone%20help%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1538894%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1539219%22%20slang%3D%22en-US%22%3ERe%3A%20Question%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1539219%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F736687%22%20target%3D%22_blank%22%3E%40Barbosaju35%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20guess%20that's%20some%20offset.%20COLUMN(G%2410)%20returns%207%2C%20plus%2024%20is%2031%2C%20it%20means%20you%20return%20value%20form%2031st%20column%20in%26nbsp%3B%3CSPAN%3E'SALES'!%24A%3A%24BH%20range%2C%20other%20words%20from%20column%20AE.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EIf%20you%20copy%2Fpaste%20formula%20to%20the%20right%2C%20within%20it%20it%20will%20be%26nbsp%3BCOLUMN(H%2410)%20and%20now%20your%20return%20value%20from%20column%20AF%20of%20the%20sheet%20Sales.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
I’m working on a spreadsheet and getting trouble to understand one formula.

ROUNDUP(VLOOKUP($D$7,'SALES'!$A:$BH,COLUMN(G$10)+24,FALSE),0)
I don’t understand this +24. Can someone help?
1 Reply

@Barbosaju35 

I guess that's some offset. COLUMN(G$10) returns 7, plus 24 is 31, it means you return value form 31st column in 'SALES'!$A:$BH range, other words from column AE. 

If you copy/paste formula to the right, within it it will be COLUMN(H$10) and now your return value from column AF of the sheet Sales.