Take a look at the Data Source and Klip Below. In order to build the “Delayed Units” Series, why is it necessary to use the LOOKUP function?

  • Because certain States have higher numbers of Units
  • Because each State has a different numbers of Cities
  • Because not all States have “Delayed” orders
  • Because there are four different Regions, and each Region has a different number of States.
  • Because the “Units” column has numerical data.