SOLVED

NEED HELP ASAP: How do I use VLOOKUP???

Copper Contributor

How do I use the VLOOKUP function?  I need to know this ASAP for a college assignment due tomorrow.

2 Replies
best response confirmed by heitle (Copper Contributor)
Solution

Hi @heitle,

Here is some information about VLOOKUP function and a link as a reference:

The VLOOKUP function is one of the most popular and powerful functions in Excel. It allows you to look up a value in a table and return the corresponding value from another column.

How to use VLOOKUP

The syntax for the VLOOKUP function is as follows:

 

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

 

  • lookup_value: The value that you want to look up in the table.
  • table_array: The table or range of cells that contains the data that you want to look up.
  • col_index_num: The column number in the table_array from which you want to return the corresponding value.
  • range_lookup: An optional argument that specifies whether you want an exact match (FALSE) or an approximate match (TRUE).

Example

The following example shows how to use the VLOOKUP function to look up the price of a product based on the product code:

 

=VLOOKUP(A2, B2:C11, 2, FALSE)

 

In this example, the lookup_value is the value in cell A2, which is the product code. The table_array is the range B2:C11, which contains the product codes and prices.
The col_index_num is 2, which is the column number that contains the prices. The range_lookup argument is FALSE, which specifies that we want an exact match.

Tips

  • The lookup_value can be a value, a text string, or a cell reference.
  • The table_array must be sorted in ascending order by the first column.
  • If the lookup_value is not found in the table_array, the VLOOKUP function will return the #N/A error.
  • You can use the VLOOKUP function to look up values in a table on another worksheet.

Reference link


Please click Mark as Best Response & Like if my post helped you to solve your issue.
This will help others to find the correct solution easily. It also closes the item.


If the post was useful in other ways, please consider giving it Like.


Kindest regards,


Leon Pavesic
(LinkedIn)

@heitle 

Why don't to google "How do I use VLOOKUP"

1 best response

Accepted Solutions
best response confirmed by heitle (Copper Contributor)
Solution

Hi @heitle,

Here is some information about VLOOKUP function and a link as a reference:

The VLOOKUP function is one of the most popular and powerful functions in Excel. It allows you to look up a value in a table and return the corresponding value from another column.

How to use VLOOKUP

The syntax for the VLOOKUP function is as follows:

 

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

 

  • lookup_value: The value that you want to look up in the table.
  • table_array: The table or range of cells that contains the data that you want to look up.
  • col_index_num: The column number in the table_array from which you want to return the corresponding value.
  • range_lookup: An optional argument that specifies whether you want an exact match (FALSE) or an approximate match (TRUE).

Example

The following example shows how to use the VLOOKUP function to look up the price of a product based on the product code:

 

=VLOOKUP(A2, B2:C11, 2, FALSE)

 

In this example, the lookup_value is the value in cell A2, which is the product code. The table_array is the range B2:C11, which contains the product codes and prices.
The col_index_num is 2, which is the column number that contains the prices. The range_lookup argument is FALSE, which specifies that we want an exact match.

Tips

  • The lookup_value can be a value, a text string, or a cell reference.
  • The table_array must be sorted in ascending order by the first column.
  • If the lookup_value is not found in the table_array, the VLOOKUP function will return the #N/A error.
  • You can use the VLOOKUP function to look up values in a table on another worksheet.

Reference link


Please click Mark as Best Response & Like if my post helped you to solve your issue.
This will help others to find the correct solution easily. It also closes the item.


If the post was useful in other ways, please consider giving it Like.


Kindest regards,


Leon Pavesic
(LinkedIn)

View solution in original post