VLOOKUP Function

- VLOOKUP lets you search for specific information.

- If you have a list of products with prices, you could search for the prices of a specific item.

Syntax: VLOOKUP("Lookup_value",table_array,col_index,[range_lookup]).

Example

Here is the example to find price of some item. We would find the price for Bananas.

First argument is the value you want to lookup. It should be in 1st column of table_array you specify.

Second argument is the range of cells in which the vlookup will search for the lookup_value and return value.

Third argument is the column number of value you want, starting with left most column of table_array.

Fourth argument is the logical value which is optional. True for closest value to search and it is defualt value. False searches for the exact value.

Close the parenthesis and press enter. The price of item will be displayed.