How to use VLOOKUP Formula in Excel?

To use the VLOOKUP formula in Excel, follow these steps:

1. 01. Syntax:
   The syntax for the VLOOKUP function is:

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

   • lookup_value: The value you want to find in the first column of the table.
   • table_array: The range of cells that contains the data you want to search through. This range should include both the column with the lookup values and the column where you want to retrieve data from.
   • col_index_num: The column number from which to return a value (1 for the first column, 2 for the second, and so on).
   • [range_lookup] (optional): This parameter can be either TRUE (approximate match) or FALSE (exact match). If omitted, it defaults to TRUE.
   • 
     

2. 02. Enter the Formula:

   • Click on the cell where you want the result to appear.
   • Type =VLOOKUP( in the formula bar.
   • Enter the lookup_value, e.g., the value you want to search for.
   • Type a comma ,.
   • Enter the table_array, selecting the range of data you want to search in.
   • Type a comma ,.
   • Enter the col_index_num, specifying the column number from which you want to retrieve data.
   • Type a comma ,.
   • Optionally, enter FALSE for an exact match or TRUE for an approximate match.
   • Close the parentheses ) and press Enter.
   • 
     

3. 03. Example:
   Let's say you have a table in columns A and B, and you want to find the price of an item with a specific code in cell D2. You would use the formula:

   =VLOOKUP(D2, A1:B10, 2, FALSE)

   This formula will search for the code in cell D2 within the range A1 to B10 and return the corresponding price from the second column.

4. 
   

5. 04. Result:
   The cell where you entered the formula will display the result of the VLOOKUP, which will be the value from the specified column in the matching row.

Remember to adjust the cell references and column numbers to match your specific data and requirements.

Share