VLOOKUP FUNCTIONS

0
11K

VLOOKUP is a powerful function in Excel that allows you to search for a value in a table and return a corresponding value from a different column. It's like looking up a phone number in a directory based on someone's name.  

Syntax:

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

Parameters:

  • lookup_value: The value you want to find.
  • table_array: The range of cells where your data is located. 
  • col_index_num: The number of the column that contains the value you want to return.  
  • range_lookup: (Optional) TRUE for approximate match (finds the next closest value if no exact match is found), FALSE for exact match only.

How it works:

  1. VLOOKUP searches for the lookup_value in the first column of the table_array.
  2. If an exact match is found, it returns the value in the corresponding row of the col_index_num column.
  3. If no exact match is found and range_lookup is TRUE, it returns the value in the corresponding row of the col_index_num column for the first row that is greater than or equal to the lookup_value.
  4. If no exact match is found and range_lookup is FALSE, it returns #N/A.

Examples:

Example 1: Exact match

Suppose you have a table of employee data, with the first column containing employee IDs and the second column containing their salaries. You want to find the salary of employee ID 1234.

You can use the following formula:

=VLOOKUP(1234, A2:B10, 2, FALSE)

This will return the salary of employee ID 1234, which is in cell B3.

Example 2: Approximate match

Suppose you have a table of sales data, with the first column containing product IDs and the second column containing product prices. You want to find the price of product ID 12345, but you only know that the product ID is approximately 12345.

You can use the following formula:

=VLOOKUP(12345, A2:B10, 2, TRUE)

This will return the price of product ID 12346, which is the closest product ID to 12345 that is in the table.

Additional tips:

  • The table_array must be sorted in ascending order by the first column if you want to use approximate matching.
  • If you want to return a value from a column that is to the left of the lookup column, you can use the HLOOKUP function instead.
  • VLOOKUP can be used to perform many different tasks, such as looking up customer information, pricing data, or employee records.

Like
1
Search
Categories
Read More
Technology
Components of BIS: Hardware, Software, Data, People, Processes
Business Information Systems (BIS) are composed of several key components that work together to...
By Business Information Systems (BIS) Course 2024-07-31 18:24:21 0 10K
Computer Programming
HTML: The Building Blocks of the Web
Definition HTML stands for HyperText Markup Language. It's the standard language used to create...
By HTML PROGRAMMING LANGUAGE 2024-08-13 03:09:45 0 8K
Education
SIMPLIFIED ECONOMICS
SIMPLIFIED ECONOMICS
By Landus Mumbere Expedito 2024-08-15 06:22:24 0 16K
Education
Steps to Write a Best CV
A well-crafted CV is essential for making a positive impression on potential employers. Here are...
By Mpatswe Francis 2024-08-31 18:31:33 2 9K
Education
S.4 SOLUTIONS TO THE PHYSICS SEMINAR QUESTIONS
S.4 SOLUTIONS TO THE PHYSICS SEMINAR QUESTIONS
By Landus Mumbere Expedito 2024-07-26 17:07:09 0 11K
Tebtalks https://tebtalks.com