Quick, clean, and to the point

Get employee information with VLOOKUP

Excel formula: Get employee information with VLOOKUP
Generic formula 

If you want to retrieve employee information from a table, and the table contains a unique id to the left of the information you want to retrieve, you can easily do so with the VLOOKUP function.

In the example shown, the VLOOKUP formula looks like this:


In this case "id" is a named range = B4 (which contains the lookup value), and "data" is a named range = B8:E107 (the data in the table). The number 3 indicates the 3rd column in the table (last name) and FALSE is supplied to force an exact match.

In "exact match mode" VLOOKUP will check every value in the first column of the supplied table for the lookup value. If it finds an exact match, VLOOKUP will return a value from the same row, using the supplied column number. If no exact match is found, VLOOKUP will return the #N/A error.

Note: it's important to require an exact match using FALSE or 0 for the last argument, which is called "range_lookup"). Otherwise, VLOOKUP might return an incorrect result.

Dave Bruns

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.

Download 100+ Important Excel Functions

Get over 100 Excel Functions you should know in one handy PDF.