Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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. Use the ID column (range A2:A23) as the lookup_array for the MATCH function. f. Specify an exact match (0) for the MATCH function. 9. Use the Start Date column (column 4) as the column_num for the INDEX function. 18. Dean also wants to identify the number of projects that have less than $5,000 of funding and calculate the average funding amount of commercial projects. Create formulas that provide this information as follows: a. In cell H8, create a formula using the DCOUNT function to count the number of projects with funding amounts less than $5,000, using the Lookup table (range A1:E23) as the database, "Funding" as the field, and the range G6:G7 as the criteria. b. In cell H13, create a formula using the DAVERAGE function to average the funding amounts for Commercial projects, using the Lookup table (range A1:E23) as the database, "Funding" as the field, and the range G11:G12 as the criteria

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

Handbook Of Hedge Funds

Authors: François-Serge Lhabitant

1st Edition

0470026634, 978-0470026632

More Books

Students also viewed these Finance questions

Question

=+multiplicity 1). If A + 1, then |A| Answered: 1 week ago

Answered: 1 week ago