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

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)

huh

Explanation: