Robyn is using lookup functions in her Excel 2019 worksheet. Which formula uses the correct syntax?

VLOOKUP uses the syntax =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]). The lookup value comes first, followed by the table to search, the column number to return a result from, and an optional range_lookup setting. Therefore, choice A has the correct argument order and names.

AI-written and checked against the verified answer.