Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials of Accounting for Governmental and Not-for-Profit Organizations

Authors: Paul Copley

12th edition

0078025818, 978-0078025815

More Books

Students also viewed these Accounting questions

Question

how are explotary tests used in software security

Answered: 1 week ago