Function to look up value in first column of a table:

The function designed to look up a value in the first column of a table and return a corresponding value from another column in the same row is VLOOKUP. The 'V' stands for 'Vertical', indicating it searches down the first column.

• HLOOKUP is incorrect because it performs a 'Horizontal Lookup', searching for a value in the first row of a table.
• LOOKUP is a more general and older lookup function, but VLOOKUP is specifically designed and more commonly used for searching the first column of a vertical table array.
• FIND is a text function used to locate one text string within another, not for looking up values in a table based on a key in the first column.