Скачать или смотреть 10 Short Formula's (Quick and Fast Work) by Aamir Ali

"Explain VLookup formula"

 =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]), searches for a specific value in the first column of a table and returns a corresponding value from another column. Use FALSE for an exact match or TRUE for an approximate match.

This video provides a quick overview of how to use the VLOOKUP formula in Excel.

Formula Components Explained 

lookup_value: The value you want to search for (must be in the first column of the range).

table_array: The range of cells containing the data.

col_index_num: The column number (starting at 1 for the leftmost column of table_array) containing the return value.

[range_lookup]: Optional, but recommended to use FALSE (or 0) for an exact match, or TRUE (or 1) for an approximate match. 

Example
To find the price of "Apple" (located in cell G6) from a table in range A4:D8, where price is in column 2:
=VLOOKUP(G6, A4:D8, 2, FALSE)

Important Notes

Excel VLOOKUP function | Exceljet.

VLOOKUP function - Microsoft Support

The VLOOKUP function syntax requires four pieces of information: * The value you want to look up, also called the lookup value * The range where the lookup valu...

How to use VLOOKUP in Excel: A Step-by-Step Beginners Guide

The syntax for VLOOKUP is: * VLOOKUP([value],[range],[column number],[false or true]) Here's an example of using VLOOKUP: 1. Select a cell in which you want to..

VLOOKUP and MATCH - Financial Edge

VLOOKUP Syntax. The VLOOKUP function appears in Excel as: =Vlookup(lookup_value, table_array, Col_index_number, [range_lookup], FALSE) The simplified Explanation.