Blog

Blog

VLOOKUP – Thinking outside the box with Schematiq

December 01, 2017 | Kevin Crooks
VLOOKUP is a widely used Excel function. It is commonly found occupying entire columns of a spreadsheet, having been entered in that very first cell and copied down. In addition to the performance penalty that such spreadsheets pay, if the formula has been mis-copied, it can be difficult to see these errors. Schematiq offers a concise and efficient alternative to VLOOKUP, that applies to all rows of your table with a single formula. Sounds too good to be true? Read More
1