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.
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 firstname.lastname@example.org