How to use Vlookup

How to use VLOOKUP

VLOOKUP looks at a value in one column, and finds its corresponding value on the same row in another column.
Vlookup Syntax
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:
What is Lookup Value?
Below is the example of putting the value inside the formula but remember “text always between the Double quotation mark in any formula”
What is Table Array?
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.
Illustration of Vlookup
Thank You for reading the article ! if you like more technical articles so share & email at

Popular posts from this blog

Concept of Cost of Capital

Emphasis of Matter & Other Matter Paragraph