Create a Search The owners would like to be able to perform a simple search by ranking to…
Create a Search
The owners would like to be able to perform a simple search by ranking to identify which apartment complex is at that ranking.
a. Type 4 in cell B2. This is the cell in which the owners will enter a ranking.
b. Insert a nested lookup function in cell B3 that will look up the ranking entered in cell B2 and return the respective apartment complex. Make sure the sample ranking of 4 returns the correct apartment complex indicated in the Summary Statistics area.
c. Type 1 in cell B2 to make sure the correct apartment complex name appears.