Page 449 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

Explanation:
• lookup_value: This is the value you want to search for in the first column of the table array (in this case, cell A7).
• table_array: This is the range of cells that contains the data. It must include the column containing the lookup
value and the column containing the data you want to retrieve (in this case, cells A3:C7).
• col_index_num: This is the column number in the table_array from which the matching value should be
returned (in this case, 3, indicating the third column of the table_array).

• range_lookup: This is an optional argument that specifies whether to find an exact match or an approximate
match. If set to FALSE, it will find an exact match.
In the given example, the VLOOKUP function searches for the value in cell A7 within the range A3:C7. It then
returns the value from the third column (index 3) of the range if it finds an exact match. If no exact match is
found, it returns an error or a value specified in the function.
After entering this formula, it will return the Price of the Product with ID 201.

Related Exercises:
1 Create a new dataset with columns ID, Product, and Price, Department. Use the VLOOKUP function to find
the price of a product with ID 104.

434

CITS : IT & ITES - Computer Software Application - Exercise 72