Tutorial by Examples

Vlookup finds some value in the leftmost column of a range and returns a value some number of columns to the right and in the same row. Let's say you want to find the surname of Employee ID 2 from this table: =VLOOKUP(2,$A$2:$C$4,3,0) The value you're retrieving data for is 2 The table you...

In most cases, the range_lookup is used as FALSE (an exact match). The default for this parameter is TRUE - it is less commonly used in this form, but this example shows one usecase. A supermarket gives a bonus based on the customers monthly spend. If the customer spends 250 EUR or more in a mon...

When the range_lookup parameter is either omitted, TRUE, or 1, VLOOKUP will find an approximate match. By "approximate", we mean that VLOOKUP will match on the smallest value that's larger than your lookup_value. Note that your table_array must be sorted in ascending order by lookup values...

The core idea of VLOOKUP is to look up information in a spreadsheet table and place it in another. For example, suppose this is the table in Sheet1: John 12/25/1990 Jane 1/1/2000 In Sheet2, place John, Andy, and Jane in A1, A2, and A3. In B1, to the right of John, I placed: =VL...