Question: In cell H10, enter an INDEX function that will use a nested INDIRECT reference to the Dept named range listed in column C (C10), and

In cell H10, enter an INDEX function that will use a nested INDIRECT reference to the Dept named range listed in column C (C10), and use the Reason field in column B (B10) as the row number to return for the department name in the referenced named range.
Nest the function inside an IF function so that issues currently displaying as a 0 will display as a blank cell. Resize the column width as needed.

** I got this much of the formula

=INDEX(INDIRECT("Dept"),Reason)

but it only recalls and displays the Dept column contents. Recall the Dept and display the Reason, I think? Then at that point, how would I get this into an IF statement?

Step by Step Solution

★★★★★

3.53 Rating (167 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

Open explorirng e07 grader hi Apartment xtox and save it as exploring e07 grader_h1_Apartment LastFirst. In cell G8 in the Summary worksheet, insert a date function to calculate the number of years...

If indexes are so important, why not index every column in every table? (Include a brief discussion of the role played by data sparsity.)

Name it Biggest Losses. Have a column named 1985 Opening Price, one column named 2003 closing price. Compute the range of the stocks, then sort them to determine the company with the greatest loss....

Making a program in C# Section 1: Enter the comment with the section title as described above. CarDealz used cars wants to build an app for their buyers to know what cars are on the approved list for...

BACKGROUND You are an information analyst working for NEE. The company president has asked you to prepare a Quantitative analysis of financial, sales, and operations data to help determine which...

The Book Wermz expanded its operations in March 2005 by purchasing an existing chain of bookstores. The total cost of the purchase was $5 million. Of this amount, $2.2 million was allocated to the...

Hi I need assistance with this assignment it is due TONIGHT. Please help. Assignment 1 Role of The Manager and The Impact of Organizational Theories on Managers (Week 3) Purpose: In the first...

Please help with my tax research project. You can research on any subject you want. I have attached three documents that will guide you. Please follow the formats in these doucments.Please write the...

The 24-hour clock (often called military time) is a method of time keeping that numbers the hours in a day beginning at 00:00 (12:00am midnight) through 23:59 (11:59pm). The standard format for a...

In 1895, Ignaz Schwinn and his partner, Adolph Arnold, incorporated the Arnold, Schwinn & Company in Chicago to produce bicycles. In the early years with bicycle products such as the "Roadster," a...

Solve then given the initial value: (yety + cos x) dx + xey dy = 0, y(/2) = 0.

Summarize Dr . Fama and Dr . Thales's view on "Market Efficiency".

Provide an explanation of each of the concepts of microeconomics and macroeconomics in your own words. Give an example of how each of these concepts helps in making business decisions. Provide about...

Consider a non-conducting rod of length 8.8 m having a uniform charge density 4.5 nC/m. Find the electric potential at P, a perpendicular distance 9.04 m above the midpoint of the rod.(Take Coulomb's...

Five equal charges Q=8 C are equally spaced on a semicircle of radius R=5 cm as shown in the Figure. Calculate the force on a charge q=7 C located at the center of the semicircle. (Your result must...

What is the equivalent resistor between the terminals a and bif you replace R1 by 24 Ohm and R2 by 21 Ohm? This combination of resistors goes to infinity by repeating itself. Ex: Resistors : Copycat...

A uniformly charged disk has radius R=3 cm and surface charge density o=4 C/m?. Calculate the electric potential at a point x=3 cm along the perpendicular central axis of the disk. (Your result must...

Use DeMorgan's Laws and the other laws to simplify ~[p V ~( q /\ ~r) ] \/ [q /\ (~q r) ] Show your work at each step!

In cell E14, enter a date function that calculates the number of days between the Initial Deadline (cell E10) and the Date Received for the first student (D14). Use mixed and relative references...

Can anyone provide clear instructions on how to do these step by step? Thank you. Message me for the Excel worksheet. Instructions: For the purpose of grading the project you are required to perform...

Please explain your solution Trial Balance Financial Statement Click Consulting Click Consulting Purpose To store the trial balance data and provide mapping to the financial statement Balance Sheet...

I am confused with how to properly nest these functions in these steps (or basically what the full function I need to type out is). Also if I am making a function and I don't want to fill out part of...

I have been trying to work on this for a while now, and this is on excel In cell H10, enter an INDEX function that will use a nested INDIRECT reference to the Dept named range listed in column C...