VLOOKUP Tutorial in Excel | Video #8
This video will help you understand the VLOOKUP function and its syntax step by step
What is a vlookup function ?
Vlookup function is a vertical lookup function, the V stands for vertical lookup, Which means it will look for the values in a table, which are placed vertical.
When do you use vlookup function?
Vlookup function is used to search for the value in the first column of a table and to return the value as per the column index number mentioned
Vlookup function can only look up for the values, which are on right side of the table and the lookup values are case sensitive
The vlookup function can return any data type such as
1. Number
2. Text
3. Date
4. String etc.
The syntax of vlookup function
VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])
Lookup_value: is the value to be found in the first column of the table, and can be a value, a reference, or a text string
Table_array: is a table of text, numbers or logical values, in which data is retrieved. Table_array can be a reference to a range or a range name
Col_index_num: is the column number in table_array from which the matching value should be returned. The first column of values in the table is column 1
Range_lookup: is a logical value: to find the closet match in the first column (sorted in ascending order ) =TRUE or omitted; find a exact match = False
Hope you have liked the video. Thank you for watching
Subscribe to my channel for more video updates:
/ @excelwithkumar
Excel Beginner to Intermediate within 60 minutes playlist:
• Getting started with Excel - The Beginners...
#MicrosoftExcel
#Vlookup
#ExcelwithKumar