Inserting the VLOOKUP

We want to create a histogram to show the distribution of volumes. You will need to start by getting the Volume data you want to show on the dashboard.

本練習屬於課程

Google Sheets 的資料視覺化

練習說明

In F16, type in the heading "Volume".
In F17, enter a formula that uses VLOOKUP to look at the date in column A and returns the Volume for that date from the ASXTable.
Copy the calculation down the column from F17 to F26.

動手互動練習

將理論付諸實踐，立即體驗我們的互動練習