New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 335th installment in their series of digital spreadsheet magic tricks, you'll learn how to increment column numbers for a VLOOKUP lookup table when you are copying the formula down across the rows (down a column).
Home
Microsoft Office How to Increment column numbers for an Excel lookup table
![](https://assets.content.technologyadvice.com/thumbnail_Logos_Wonder_How_To_color_light_21e00e7b4a.webp)
By getexcellent
May 4, 2010 11:13 PM
![Excel spreadsheet displaying a recipe with ingredients and instructions.](https://assets.content.technologyadvice.com/634758683250378416_b8d2e10764.webp)
Just updated your iPhone? You'll find updated Apple Intelligence capabilities, new wallpapers, and enhancements to Calculator, PDF cropping, and Live Voicemail, among other useful features. Find out what's new and changed on your iPhone with the iOS 18.3 update.
Comments
Be the first, drop a comment!