When Baidu knew it today, someone was asked about the condition Vlookup in Excel. Several experts knew that Vlookup was used to answer the question. Unfortunately, they did not pass the test and copied others' answers directly. You can find a detailed answer to this question:
Q: If the data in Table sheet1 is known as follows, how can we reference the following in Table 2 sheet2: how can we display the corresponding physical score in column B when the student ID appears randomly?
First, we will introduce several Vlookup parameters used by the function. Vlookup is a function used to judge the referenced data. It has a total of four parameters, which are:
1. Judgment Conditions
2. Tracking Data Area
3. Return the data of the nth column.
4. Exact match
The formula should be as follows:
= Vlookup (A2, sheet1! $ A $2: $ F $100,6, true)
The following describes how to use parameters in the Vlookup function example:
1. A2 is the condition for judgment. That is to say, if the data in column A in Table sheet2 is the same as that in Table sheet1, it can be referenced;
2. sheet1! $ A $2: $ F $100 is the region where data is tracked. Because the data to be referenced is in column F, the region to be tracked is at least in column F, $ is absolute reference (for absolute reference, refer to here );
3. 6. This is the number of columns returned. For example, the physical value is 6th columns, so it should be 6. If the English value is required, it should be 5.
4. Whether it is an absolute reference. If it is true, if it is an approximate condition, then enter false (the approximate value is mainly used for finance and computation with the decimal point)
5. Vlookup is a vertical judgment. If it is a horizontal judgment, you can use the hlookup function.
The result is as follows:
I wonder if you will use the Vlookup condition lookup function. If you are interested, try this example. This example is closely related to Excel Data Reference. For more Excel files, refer to here.
This article is original graph, original address
Http://www.utosee.com/post/vlookup.html reprinted please keep.