Respuesta :

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)