- Vlookup is a function used in the Excel to find value in a table or range by row. Example price of a single product in a store having lacks of products.
- Syntax of function is: =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).
- Select the column in which you want to enter the value for lookup.
- Then write the function to the cell next the cell which you are going to write the value.
- After writing the function then write a value like product code in the cell and "Enter".
- Then the output will be seen in the cell written with function.
Notes:
