How to use the VLOOKUP Function in Excel:
The VLOOKUP Function looks for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify.
The following example list cities in cells C4:C7 and the population in cells D4:D7. Cell G4 contains the value that we want to look up (Dallas) and cell H4 contains the formula that returns the results (1,379,735).
The formula in cell H4 is: =VLOOKUP(G4,C4:D7,2,FALSE)
If using the Function Arguments window to enter your formula, it would look like the below image:
– The Lookup Value would be the city name that you are trying to get the population for. (The lookup value must be the to the left of the results value. If you wanted to get the city based on the population, then you would need to have the Population column before the city column.)
– The Table Array would be the table where the information is stored.
– The Column Index Number is the column that contains the information you want returned. In this example, you are looking for the Population Column (Column D), which is the 2nd column in the table we are looking at. Column C (City) would be the 1st column. If you had a 3rd column that was labeled Houses and that is the column that contained the information you needed, then you would enter 3 for the column index number.
– The Range Lookup can be either TRUE or FALSE. If you enter TRUE, the formula will look for the closest match. If FALSE, the formula will return an exact match if there is one. In the example we used above, we used FALSE for exact match.