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.Este ejercicio forma parte del curso
Data Visualization in Google Sheets
Instrucciones del ejercicio
- In
F16
, type in the heading "Volume". - In
F17
, enter a formula that usesVLOOKUP
to look at the date in columnA
and returns theVolume
for that date from theASXTable
. - Copy the calculation down the column from
F17
toF26
.
Ejercicio interactivo práctico
Pon en práctica la teoría con uno de nuestros ejercicios interactivos
