Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Use VLOOKUP Function in Microsoft Excel to Find the Specified Data

Date:2019-8-14 Author:Cordelia

VLOOKUP is a very useful Excel function which can easily search through a column and find the corresponding data. For example, you can search for the score of a student in class quickly according to his or her name.

The basic formula for VLOOKUP is:

=VLOOKUP (lookup_value,table_array,col_index_num,range_lookup)

lookup_value” refers to the keyword for searching;

table_array” is the range of matching object;

col_index_num” indicates the column number of the result;

range_lookup” refers to the matching mode, which contains two options: “0” for accurate matching and “1” for fuzzy matching.

Assuming there’s a very long list of record in the table below, now I want to find the score of someone, how can I do it with VLOOKUP function?

How to Use VLOOKUP Function in Microsoft Excel to Find the Specified Data

First, input the formula in the cell to output the search result which should be F2 in my case. So I click F2 and hit the small icon of “fx” above the table.

How to Use VLOOKUP Function in Microsoft Excel to Find the Specified Data

Type “VLOOKUP” directly in the textbox of Search for a function and hit Go.

How to Use VLOOKUP Function in Microsoft Excel to Find the Specified Data

Click VLOOKUP in the section of Select a function and click OK to insert the formula.

How to Use VLOOKUP Function in Microsoft Excel to Find the Specified Data

Then you can input the value of each factor of the formula. For example, I want find the score of F in the table, so the Lookup_value should be “F“. And his score is in the third column, so the Col_index_num is doubtlessly “3“. To find an accurate result, I can set the Range_lookup as “0“.

How to Use VLOOKUP Function in Microsoft Excel to Find the Specified Data

As for the Table_array, a convenient way is clicking the small arrow on the right of the textbox, then hold and drag the left mouse to select all the cells in the table. The range of table will be inserted to the textbox accordingly. Click that small arrow again, we can get back to Function Arguments window and continue editing.

How to Use VLOOKUP Function in Microsoft Excel to Find the Specified Data

How to Use VLOOKUP Function in Microsoft Excel to Find the Specified Data

Now all the textbox have been filled up, you can see the formula in F2 is also completed at the same time. In fact, you can directly complete and input the formula after being familiar with the function.

How to Use VLOOKUP Function in Microsoft Excel to Find the Specified Data

Click OK to close the Function Arguments window. VLOOKUP function has found the data I’m looking for in F2.

How to Use VLOOKUP Function in Microsoft Excel to Find the Specified Data

This is the basic application of VLOOKUP function in Excel. In practical work, there are much more usages of it for sure. I’ll probably continue this topic in future posts.

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

1 thought on “How to Use VLOOKUP Function in Microsoft Excel to Find the Specified Data”

  1. ปั้มไลค์ says:

    Like!! Great article post.Really thank you! Really Cool.

Leave a Reply

Your email address will not be published. Required fields are marked *