Question formula

[Barbosaju35]

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?

[#2]

@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.