The number of that column from which we want to retrieve the matched value. Table_array: – This is the array of selected cells from which the VLOOKUP will find and retrieve the matched value.Ĭol_index_num: – It means Column Index Number.

This value is always written in the first column of the selected cells(table array) because VLOOKUP only finds the value in the vertical order from the selected cells. Lookup_value: – The lookup value is that value, which will find the exact matched value from the selected cells(table array) with this formula. =VLOOKUP(lookup_value, table_array, col_index_num, )

Now, We will explain the Arguments of the formula.

It retrieves data based on column number.

We can use 1 and 0 instead of True and False respectively.

VLOOKUP always finds the first matched value from the selected cell(Table_array) and retrieve it.

This formula provides two types of matched value i.e.

It can only look up the value from the Selected cell(Table_array) from left to right side. So, we do not need to find the values individually from the selected date and then copy, paste it.

it will show the matched value in the column/row where you want.

It helps in saving time and doing work more efficiently.

With the help of VLOOKUP, we can retrieve the numbers of exact or approximate matched value in the seconds.

The lookup value must be in the first column in the selected cells(table array). It can only look up and retrieve the values in the vertical order. It supports approximate and exact matched value. In VLOOKUP, V stands for vertical and with the help of this formula, we can retrieve the matched value from the selected cells(table array) from left to right means in vertical order.

How to use vlookup in excel