VLOOKUP Formula of MS Excel

 VLOOKUP Formula

The VLOOKUP formula in Excel allows you to search for a specific value in the first column of a table and return a corresponding value from another column in the same row. The basic syntax for the VLOOKUP formula is:

scss
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

lookup_value is the value you want to search for.
table_array is the range of cells that make up the table you want to search in.
col_index_num is the column number in the table that you want to return a value from.
range_lookup is an optional argument that specifies whether you want an exact match (0 or FALSE) or an approximate match (1 or TRUE).

For example, consider the following table in cells A1:B5:

yaml
 A       B
1 Name  Salary
2 John   5000
3 Jane   6000
4 Bob    7000
5 Alice  8000

If you want to search for the salary of John, you could use the following formula:

php
=VLOOKUP("John", A1:B5, 2, FALSE)

This formula would return 5000, which is the salary corresponding to the name "John" in the table.