What does the third argument (3) refer to in the following formula: VLOOKUP(10005, A1:C6, 3, FALSE)

The VLOOKUP is an excel function which allows searching for a particular phrase or word within a table by using the appropriate syntax. The third argument means the column number in the range which contains the return value.

The third argument in the formula given is 3. This means that the third column in the range specified as (A1:C6). Here, the value 3 refers to the third column which is column C.

Therefore, the third argument is the column number in the range which contains the return value.

Learn more : link

The answer is "number of the column containing the return value".

Explanation:

In Excel, the "VLOOKUP" method is used to perform the vertical search by looking for both the value during the user table and retrieving the number of the index number location in the same row. It is a built-in function, which is classified as a Lookup or Reference worksheet function, and the following function can be defined as follows:

answerstandard;