Excel's VLOOKUP function lets you find data in columns in reference to the first column. Learn how to create it manually or build it easily.

Following on from our time saving Excel shortcuts, we continue offering updated advice for the time-sensitive spreadsheet enthusiast. Back in 2013 John Gagnon wrote a very popular post about VLOOKUP ...

Excel groups functions into 12 categories: Compatibility, Cube, Database, Date and Time, Engineering, Financial, Information, Logical, Lookup & Reference, Math & Trigonometry, Statistical and Text.