Ask Question

how do i create an advanced search using the search criteria in the range K2:S3 and the inventory data where the results will be displayed in the search results (starting in cell K10).

+3
Answers (1)
  1. 11 October, 02:21
    0
    Create an advanced search using the search criteria in the range K2:S3 and the inventory data where the results will be displayed in the search results (starting in cell K10).

    Explanation:

    In cell B2, enter the value from A7. Insert a function in D2 that will return the arrival date of any vehicle based on which VIN is entered in B2 (Hint: Start with an INDEX function. Before you use a nested MATCH function, specify which column number you will be returning.) Insert a function in F2 that will return the Special Notes of any vehicle based on which VIN is entered in B2 (Use the same hint from the previous step.) Enter the following values for the advanced search criteria in the range K3S3: Year = 2018 Type = Sedan GPS = Yes Create an advanced filter using the search criteria in the range K2:S3 and the inventory data where the results will be displayed in the search results (starting in K10). Verify results populate as expected.
Know the Answer?
Not Sure About the Answer?
Find an answer to your question 👍 “how do i create an advanced search using the search criteria in the range K2:S3 and the inventory data where the results will be displayed ...” in 📗 Computers & Technology if the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers