78.2k views
1 vote
Complete each sentence to describe features of the VLOOKUP function. The VLOOKUP function structure begins with =VLOOKUP( , …) To use the VLOOKUP function, the lookup value should be in the of the table.

User Giusti
by
7.0k points

2 Answers

7 votes

Answer:

The complete sentences are:

The VLOOKUP function structure begins with =VLOOKUP(value, table, col_index, [range_lookup])

To use the VLOOKUP function, the lookup value should be in the first column of the table.

Step-by-step explanation:

Required

Complete the given sentence with the right values

In Excel, the syntax of the VLOOK function is:

=VLOOKUP (value, table, col_index, [range_lookup])

value -> The value to look up to and it should be located in the first column of the table

table -> The table name

col_index -> The column number to check

[range_lookup] -> This is optional and it returns either true of false depending on the result of the query,

User Biraj Zalavadia
by
7.0k points
5 votes

Answer:

Complete each sentence to describe features of the VLOOKUP function.

The VLOOKUP function structure begins with =VLOOKUP(lookup value, table array... )

To use the VLOOKUP function, the lookup value should be in the first column of the table.

Step-by-step explanation:

User Svinja
by
6.5k points