### How to use Vlookup

### How to use VLOOKUP

V

**LOOKUP**looks at a value in one column, and finds its corresponding value on the same row in another column.
For vlookup syntax is lookup_value, table_array, col_index_num, [range_lookup]

**What is Lookup Value?**

Lookup value means which value do you want to find out whether by selecting a cell or by putting the value inside the formula such as:

Below is the example of selection of cell:

Below is the example of putting the value inside the formula but remember

*“text always between the Double quotation mark in any formula”*
Table array, you enter a range of cells, such as D2:F20. That range is called the

**table_array****What is Col index Num?**

Which column value you want return.

Thank You for reading the article ! if you like more technical articles so share & email at haris-sultan@live.com