Adding the calculation

Your next task is to select the dates you want and then add in a VLOOKUP calculation to look at the date selected and find an exact match for the Open, High, Low, and Close Data from your dataset.

Remember that VLOOKUP() will take four arguments.

1. The search key (in this case, the date in Column A).
2. The range of data to search (in this case, the data in the sheet ASX Data).
3. The column index to retrieve where 1 is the column of your search key, and subsequent columns are those that you are trying to access (i.e. 2, 3, 4, and 5).
4. Whether you want an exact match, which can be specified by providing FALSE.