Answered step by step
Verified Expert Solution
Question
1 Approved Answer
16. Go to the Lookup worksheet, which lists project details, including the ID code that staff in the Development Division use to refer to
16. Go to the Lookup worksheet, which lists project details, including the ID code that staff in the Development Division use to refer to the projects. Dean wants to find a simple way to look up a project name based on its ID. Create a formula that provides this information as follows: a. In cell H3, begin to enter a formula using the VLOOKUP function. b. Use the Project ID (cell H2) as the lookup value. C. Use the Lookup table (range A2:E23) as the table_array. d. Use the Project Name column (column 2) as the col_index_num. Specify an exact match (FALSE) for the range_lookup. e. 17. Dean also wants to look up the start date of each project. Instead of using the VLOOKUP function, he suggests using the INDEX and MATCH functions, which are faster with large amounts of data. Create a formula that provides the start date of a project as follows: a. In cell H4, begin to enter a formula using the INDEX function. b. Use the Lookup table (range A2:E23) as the array. C. For the row_num argument, use the MATCH function. d. Use the Project ID (cell H2) as the lookup_value for the MATCH function. e. f. g. Use the ID column (range A2:A23) as the lookup_array for the MATCH function. Specify an exact match (0) for the MATCH function. Use the Start Date column (column 4) as the column_num for the INDEX function.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started