VLOOKUP FUNCTIONS

0
11KB

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
Pesquisar
Categorias
Leia mais
Computer Programming
Comparing Data Types and Conditional Expressions
Comparing Data Types: In Python, you can compare data types using the type() function. This...
Chemistry
UACE WAKISSHA CHEMISTRY PAPER 1 GUIDE 2014
UACE WAKISSHA CHEMISTRY PAPER 1 GUIDE 2024
Por Advanced Level chemistry 2024-08-31 09:56:47 2 12KB
Physics
MATIGO PHYSICS PAPER 1 2024
MATIGO UACE PHYSICS PAPER 1 2024
Por Question Bank 2024-09-05 17:26:27 0 13KB
Computer Programming
Bold Text in HTML
To make text bold in HTML, you can use either the <b> or <strong> element. Both...
Por HTML PROGRAMMING LANGUAGE 2024-08-29 01:49:28 0 8KB
Computer Programming
Keywords, Multiple Output, and Documentation
1. Keywords: Keywords are reserved words in Python that have special meanings and cannot be...
Tebtalks https://tebtalks.com