Examples of using Excel VLOOKUP functions

In this course, you will learn how to use VLOOKUP to find the values you want in an Excel list or table, and to VLOOKUP queries over two spreadsheets, which are described in detail below!!

VLOOKUP syntax: VLOOKUP (lookup_value, table_array, Col_index_num, [range_lookup])

Each of these arguments is explained by the following case:

Case one: Use the VLOOKUP function to find the desired value in the table

The above table is an Excel table that contains 5 columns, the leftmost column is "name", the right is "gender", "Student Number", "Class" and "grade", where I want to use "name" as the lookup field, and then output the corresponding "score", where we use the "Vlookup" function, Because I do not want to go to the list to find each one;

Let's take a look at the animation demo effect:

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/Office/excel/