What is VLOOKUP FORMULA

Question

Accepted Answer

VLOOKUP is a formula in Excel used to search for a specific value in a column and return a corresponding value from another column.

VLOOKUP stands for Vertical Lookup.
It is commonly used to find data in large datasets or tables.
The formula takes four arguments: lookup value, table array, column index number, and range lookup.
The lookup value is the value to search for.
The table array is the range of cells that contains the data.
The column index number is the column from which to return the value.
The range lookup is an optional argument that specifies whether the lookup value should be an exact match or an approximate match.
Example: =VLOOKUP(A2, B2:D10, 3, FALSE) will search for the value in cell A2 in the range B2:D10 and return the value from the third column.
VLOOKUP can be combined with other functions to perform more complex calculations and data analysis.

Accepted Answer

Vlookup is a lookup function, it is lookup verticle in table array. =Vlookup (lookup value,table array,column index number,0/1)

1.lookup value must be contained in table's first column

2.column index no. Table array me jis column se value chaiye uska numbers

Popular interview questions of MIS Executive and Analyst