The MIN function returns the smallest value in a set of numbers. For example, if the range A$1$:A$3$ contains the values $6,25,$ and $38,$ then the formula $=$MIN$($A$1$:A$3)$ returns the number $6,$ because it is the smallest of the three numbers:

$=$MATCH$($lookup$\_$value, lookup$\_$array, match type$)$

The MATCH function searches for a specified item in a range of cells and returns the relative position of that item in the range. The lookup$\_$value is the value to match, the lookup$\_$array is the range of search, and match type indicates the type of match $($use $0$ for an exact match$).$

For example, if the range A$1$:A$3$ contains the values $6,25,$ and $38,$ then the formula $=$MATCH$(25,$A$1$:A$3,0)$ returns the number $2,$ because $25$ is the second item in the range.

$=$INDEX$($array$,$ column$\_$num$)$

The INDEX function returns the value of an element in a position of an array. For example, if the range A$1$:A$3$ contains the values $6,25,$ and $38,$ then the formula $=$INDEX$($A$1$:A$3,2)525,$ because $25$ is the value in the second position of the array A$1$:A$3.($Hint: Create three new columns. In the first column, use the MIN function to calculate the minimum distance for the customer in that row. In the second column use the MATCH function to find the position of the minimum distance. In the third column, use the position in the previous column with the INDEX function referencing the row of distribution center names to find the name of the distribution center that should service that customer.$)$