Jul 22 2020 10:12 AM
Jul 22 2020 12:02 PM
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.