Chapter 2, Problem 25PE

The Excel file $S\&P500$ provides open, high, low, and close values for the $\text{S\&P 500}$ index over a period of time.

1. Enter any date (using the format month/day/year) within the range of the data in cell $\text{G2}$. Use a MATCH function in cell $\text{G3}$ to find the row in the database that corresponds to this date.
2. Write an INDEX function in cell $\text{G4}$ that finds the closing value on this date using your answer to part a.
3. Combine the MATCH and INDEX functions in parts a and b into one function that displays the closing value in cell $\text{G5}$ .