Code School for Kids

Excel's VLOOKUP Function

VLOOKUP is a powerful reference function within Excel. If you need to lookup values in a table or range of cells to use somewhere else in your spreadsheet VLOOKUP may be just the ticket. In many cases this function can replace spreadsheet logic that utilizes nested IF functions. VLOOKUP can be in two ways, either as an exact match or approximate match. Typically when you are looking up numeric values approximate match is used, while for text lookups exact matches are most common. This tutorial demonstrates how to do VLOOKUP in Excel 2016, but this function has been around for a long time and works the same in any version of Excel including MAC OS versions.