The `LOOKUP` function in Excel facilitates searching for a value within a specified range and retrieving a corresponding value. It offers two distinct syntax configurations: \vspace{0.3cm}1. Vector Form: - Syntax: \[ =\text{LOOKUP(lookup\_value, lookup\_vector, result\_vector)} \] - Description: - This form locates a specified value (`lookup value`) within a single row or column (`lookup vector`) and returns the associated value from a parallel row or column (`result vector`).
- Illustration: Given product codes and their corresponding prices, such as \[ \text{Product Code: A101, B202, C303; Prices: 500, 700, 900.} \] To ascertain the price for product code `B202`, the following formula is employed: \[ =\text{LOOKUP("B202", A2:A4, B2:B4)} \] Expected Output: 700\vspace{0.5cm}2. Array Form: - Syntax: \[ =\text{LOOKUP(lookup\_value, array)} \] - Description: - This form searches for a specified value (`lookup value`) within a two-dimensional array and retrieves the corresponding data. - Illustration: For student names and their respective grades: \[ \text{Names: John, Sarah, Mike; Grades: A, B, A+.} \] To determine the grade for "Sarah," the applicable formula is: \[ =\text{LOOKUP("Sarah", A2:A4, B2:B4)} \] Expected Output: B \vspace{0.5cm}