Which function can you use to lookup a value in a vertical range?

The function used to look up a value in a vertical range is VLOOKUP(). This function is specifically designed to search for a value in the first column of a specified range and return a corresponding value from a column to the right within that same range.

When using VLOOKUP(), the user specifies the following parameters: the value to search for, the range of cells containing the data (known as the table array), the column number from which to retrieve the value, and an optional argument that can define whether the match should be exact or approximate. This makes VLOOKUP() particularly useful in scenarios where data is organized vertically in columns.

For instance, if you have a table of employee names in one column and their salaries in another, VLOOKUP() would allow you to find an employee's salary by searching for their name in the vertical list of names.

While LOOKUP() can also be used for searching values, it works more generally and is less straightforward for a vertical lookup scenario compared to VLOOKUP(). INDEX() retrieves a value from a specific position in a range, but it doesn't inherently perform a lookup by itself. XLOOKUP() is a newer and more versatile function that can do both vertical and horizontal lookups and is similar