Question

5. If you replaced the number 5 for the column_num with a 6 (the third argument In the VLOOKUP function), what descriptive information would return instead of Customer_St

Answer 1

Answer:

It will return the 6th column, next to Customer_St (5th column)

Explanation:

The third argument in VLOOKUP controls the column to be returned as a result. If it currently has a 5, that returns a column named Customer_St, changing it for a 6, will make the function to return the 6th column instead.

In Excel, VLOOKUP function syntax is as follows

VLOOKUP (valueToLookup, tableWithDataToSearch, columnToReturn, [lookupModifier])

The arguments mean:

• valueToLookup: data to search in the first column of the table selected as second argument (tableWithDataToSearch)

• tableWithDataToSearch: The table containing both the data to be searched and the data to be returned as result.

• columnToReturn: The number of the column with the data to be returned in case of a match.

• lookupModifier (optional): Allows only TRUE or FALSE value. It will change the behaviour of the lookup. FALSE forces an exact match, while TRUE allows an approximate search (data must be previously sorted)