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.
- The search key (in this case, the date in Column A).
- The range of data to search (in this case, the data in the sheet
ASX Data). - 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, and5). - Whether you want an exact match, which can be specified by providing
FALSE.
이 연습은 강의의 일부입니다
Google Sheets로 배우는 데이터 시각화
연습 안내
- Fill in the empty dates in cells
A25andA26with 10-09-17 and 10-10-17 (respectively), using the list provided through the data validation. - In cell
B17useVLOOKUP()to look for the date in your dataset and show the corresponding Open data. Then, copy the formula down through the rest of the column. Don't forget to use partial absolution to make it easy to copy your formula to other cells! - Repeat the process in cells
C17,D17, andE17to look for the figures in the dataset that correspond to the column headings (again, copying the formulas down through the respective columns).
