Use the VLOOKUP function in Excel to query the value of a sequence

With a simple example, the number of columns is relatively small, it looks clearer, we can see changes in the number of medals in each country in the Olympics or other competitions, so how do we find the total number of medals in the country?

The function we use is VLOOKUP, which is a longitudinal query function that returns the value of the column query by column lookup;

You can enter =vlookup directly in cell H2 (this time Excel will prompt for 4 parameters)

=vlookup (G2, $A $2: $E $5,0)

You can also click the FX function in the blank field to come up with a dialog box as follows:

first parameter: the value to find; Obviously, we want to make China correspond to H2, here we enter G2; the second argument: the area to look for; Enter the area we want to find (absolute reference), which is "$A $ 2: $E $"Third parameter: Returns the number of columns of data in the range; The third parameter is to return the fifth Column Total medal number is 5 the fourth parameter: accurate /fuzzy;0

When the function is entered as complete as required, the value corresponding to that column is returned in the table, and we can check if it is correct.

OK, it's all right.

Use the VLOOKUP function in Excel to query the value of a sequence