Forum Discussion
Question formula
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?
ROUNDUP(VLOOKUP($D$7,'SALES'!$A:$BH,COLUMN(G$10)+24,FALSE),0)
I don’t understand this +24. Can someone help?
1 Reply
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.
