Tag Archives: COLUMN

Variable vlookup offsets

Challenge: I want to future-proof the column number returned in my VLOOKUP formula. VLOOKUP is a hugely useful formula in Excel. Apart from the basic mathematical operators and the IF statement, there’s nothing that touches it in terms of how … Continue reading