Q. What does the VLOOKUP function do ?

Explanation by: Ravi Chauhan

The VLOOKUP function in Excel is used to (3) find related records. VLOOKUP stands for "Vertical Lookup" and is a powerful function that allows you to search for a specific value in the leftmost column of a table and retrieve a corresponding value from a different column within the same table. It is commonly used to look up and retrieve data from a large dataset or table based on a specific criteria. By specifying the lookup value, the table range, the column index number, and optionally indicating whether to perform an exact or approximate match, the VLOOKUP function can locate the desired value and return a corresponding value from a specified column. This is particularly useful when working with large datasets or when you need to retrieve specific information based on certain criteria. So, the correct answer is (3) finds related records.