Question: 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
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 2024 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
Get step-by-step solutions from verified subject matter experts
