Shulou(Shulou.com)11/24 Report--

The original title: "30 seconds to teach you the Vlookup function, simple enough to cry!" "

Hello, everyone. I'm the lovely and witty little Qiu E ~

Many students say that functions are difficult to learn, and it gives them a headache.

In fact, there are some functions whose basic usage is not difficult, such as the Vlookup function.

When you encounter the problem of query matching, it is simply not too easy to use.

For example, it can be used to check data, quickly import data between multiple tables, and so on.

Today, Xiao E will talk in detail about the basic usage of the Vlookup function!

Let me give you a brief introduction to the Vlookup function. Its basic syntax:

= VLOOKUP (lookup_value,table_array,col_index_num, [range-lookup]) it has four parameters:

Parameter 1: the value to find

Parameter 2: the area to find

Parameter 3: returns the column number of the data in the lookup area

Parameter 4: exact match / approximate match.

To put it more popularly, it is solving four problems:

Looking for what?

Where can I find it?

Which column are you looking for?

How do I find it?

Let's give an example to deepen our understanding. We need to find the corresponding woman from the picture below, and then fill in the "Sheet1".

Enter the Vlookup function first:

Vlookup ▋ step 1: what are you looking for? Looking for the male knight-errant's female companion, so the first parameter is "male knight-errant", select the first male chivalrous "Qiao Feng", that is, A3 cell.

Formula:

= VlookupA3, ▋ step 2: where can I find it? Locate the parameter table, namely "Sheet2", and click

Select the lookup area, columns B and C, that is, parameter 2.

Formula:

It is explained here that the search area needs to contain both "search value" and "return value".

As shown below:

Step 3 of ▋: which column do you find? Which column here, notice that the selected area is listed first in column 1.

In the above, we selected columns B and C, so column B is column 1 and column C is column 2.

The woman is in column C, so enter the number 2.

Formula:

Step 4: how to find ▋? The Vlookup function has two ways to find it, approximate matching and exact matching.

In the formula, "1" is used for approximate matching and "0" for exact matching.

Enter "0" because you are looking for a specific object.

Formula:

= Vlookup (A3GHERE Sheet2century Blane CJRO) (the whole formula says: look for a man in the worksheet "Sheet2", and return the corresponding woman when you find it. )

Return to the car! Drop-down fill, done ~

Four parameters of ▋ Vlookup: what are you looking for?

Where can I find it?

Which column are you looking for?

How do I find it?

All right, have you learned the basic usage of the Vlookup function?

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: witty Qiu Xiao E

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.