Question

In the formula =VLOOKUP(“shovel”, B2:D12, 3, FALSE), which part is the lookup value parameter?

A.
shovel

B.
FALSE

C.
B2:D12

D.
3

Answer 1

In the formula =VLOOKUP(“shovel”, B2:D12, 3, FALSE), the part that is the lookup value parameter is B2:D12.

What are the parameters in VLOOKUP?

The VLOOKUP is known to often have four arguments:

• lookup_value,
• table_array,
• column_index_num,
• range_lookup

This value is known to be a LOOKUP searches which is in an array. The lookup_value argument is one that be seen to be a  number, text, a logical value.

Note that If LOOKUP is one that did not see or find the value of lookup_value, it is said to often uses the largest value in the array that is known to be smaller than or one that is equal to lookup_value.

Hence, In the formula =VLOOKUP(“shovel”, B2:D12, 3, FALSE), the part that is the lookup value parameter is B2:D12.

Learn more about value parameter from

https://brainly.com/question/24076677

#SPJ1