Question: You want to use a function that extracts data from another worksheet based on the school or college name entered in cell B2. The data

 You want to use a function that extracts data from another

You want to use a function that extracts data from another worksheet based on the school or college name entered in cell B2. The data entered in cell B2 must match an existing worksheet name: Art, Business, or Engineering. In cell B3, insert an INDIRECT function that uses data in cell B2 to extract the value in cell H13 from the respective worksheet. After entering the function, check the Engineering worksheet to make sure the value in cell B3 in the Donors worksheet is the same as the value of cell H13 in the Engineering worksheet. In cell B2 in the Donors worksheet, type Art and check the results again. Your next task is to sort and filter data in the Art worksheet. Display the Art worksheet. In cell A17, insert a SORT function with a nested FILTER function. The nested FILTER function uses data in the range A2:H11 where the range H2:H11 is less than the value in cell H15($15,000). The results are then sorted in alphabetical order by last name

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 Databases Questions!