Question

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

Answer 1

Answer:

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:

• In the 1st parameter, it is used to watch the value for the match.  
• In the 2nd parameter, it is used to search the table.
• In the 3rd parameter, it is used as the column number representing the return value.  
• In the 4th parameter, it is used to return only if the same match is found.