Robyn is using lookup functions in her Excel 2019 worksheet. Which formula uses the correct syntax?
A
=VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)B
=VLOOKUP(table_array, lookup_value, col_index_num, range_lookup)C
=VLOOKUP(lookup_value, table_array, col_index_num, value)D
=VLOOKUP(table_array, lookup_value, col_index_num, value)