Question

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

Answer 1

Step-by-step explanation:

Hello,

the logic is a below

=VLOOKUP(

lookup_value what you want to look up,

table_array where you want to look for it,

col_index_num the column index in the range containing the value to return,

range_lookup

is a TRUE or FALSE value. return an Approximate or Exact match

)

hope this helps

Answer 2

in more simple words to us Edge users

Answer Shown by the guy below us is A

well it seems to be

Step-by-step explanation:

Edge2020