Solution

The correct Excel function used to look up a value in a table based on the first column is VLOOKUP.

 

• VLOOKUP stands for "Vertical Lookup." It is used to search for a value in the first column of a table and return a value in the same row from another column you specify.
• The function works by searching vertically down the first column of the specified range to find the lookup value, and then it retrieves the corresponding value from the specified column within the same row.

 

Why Other Options are Incorrect:

• (b) HLOOKUP: This function is similar to VLOOKUP but is used for horizontal lookups. It searches for a value in the first row of a table and returns a value from the same column in a specified row.
• (c) A1LOOKUP and (d) ALOOKUP: These functions do not exist in Excel.