Question: Enter the appropriate functions in cell L 5 to return the name of the greenhouse from the range P 5 :R 1 7 where the

Enter the appropriate functions in cell L5 to return the name of the greenhouse from the range P5:R17 where the plant in A5 will be grown. The specific greenhouse where a plant is grown is based upon each plants days to harvest and hardiness. For example, since broccoli takes 49 days to harvest and is a hardy plant, it should be planted in GH1(greenhouse 1). Use an IF function and an INDEX function to retrieve the greenhouse name for plants to be grown for the 2021 season. Plants that will not be planted should display a blank. Write the function(s) so that they can be filled down column L and return the name of the greenhouse for each of the plants in column A.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!