We get a new function window showing in the below mention pictures.Also, click on the function icon, then manually write and search the formula.Click on formula tab > lookup & reference > click on vlookup.

We can also use 0 for false and 1 for true matching.

False – exact match if an exact match is not found, then it will return an error.

True – approximate match if an exact match is not found, use the closest match below the lookup value.

The argument can be set to true or false, which means:

Range lookup (optional argument) defines what this function should return if it does not find an exact match to the lookup value.

If you are only using it for data matching, you can put 1, but if you want to get a value from another column to match the lookup value, you need to put column no from matching column no.

Column index number (required argument) – an integer specifying the column number of the supplied table array that you want to return a value from.

We can say that this is a matching table. The vlookup function searches in the left-most column of this array.

Table array (required argument) – it is the data array that is to be searched.

Where you want or get the value from another table.

Lookup value (required argument) is the value that we want to look up in a table column.

There are four arguments in the vlookup function, which is below mention: The vlookup function uses of the arguments:. Excel functions, formula, charts, formatting creating excel dashboard & others

How to use vlookup in excel list box