Gia Holt

Computers & Technology

2 February, 18:27

Enter a nested lookup function in cell E4 that uses the cells E2 and E3 to return a specific sales record. For example, using the current data, you want the function to return the third quarter sales for Erica. Click the Database worksheet tab and enter conditions in the Criteria Range for Domestic sales reps that made 240000 or more in sales. Perform an advanced filter based on the criteria range. Set the filter to copy the new data to the range A22:G22.