What Is Vlookup And Its Syntax In Excel In Hindi || By Excel Classes

Today I have created video on vlookup formula . Here I have done 4+ example on lookup formula.

VLOOKUP in Excel is useful for looking for specific information in your worksheet.

Learn all about it in this Excel VLOOKUP tutorial.
In its simplest form, the VLOOKUP function says: =VLOOKUP(Value you want to look up, range where you want to lookup the value, the column number in the range containing the return value, Exact Match or Approximate Match – indicated as 0/FALSE or 1/TRUE).

The VLOOKUP function performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position.

The VLOOKUP function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet


VLOOKUP is an Excel function to lookup and retrieve data from a specific column in table. VLOOKUP supports approximate and exact matching, and wildcards (* ?) for partial matches. The "V" stands for "vertical". Lookup values must appear in the first column of the table, with lookup columns to the right.

Purpose
Lookup a value in a table by matching on the first column
Syntax

=VLOOKUP (value, table, col_index, [range_lookup])
Excel VLOOKUP Function: VLOOKUP is an Excel function to lookup and retrieve data from a specific column in table. Lookup a value in a table by matching on the first column. The matched value from a table. =VLOOKUP (value, table, col_index, [range_lookup]) value.