# 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

###### Question:

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 (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. I need it to recall the Dept and display the Reason, I think? Then at that point, how would I get this into an IF statement?
I feel like I dont understand the instructions, and I know I am not that great on excel.

### A square room has a tiled floor with 81 square tiles. How many tiles are along an edge of the room?

A square room has a tiled floor with 81 square tiles. How many tiles are along an edge of the room?...

### Which of the following best supports the inference that the speaker is having a difficult time forgetting

Which of the following best supports the inference that the speaker is having a difficult time forgetting his love? a. and this maiden she lived with no other thought / than to love and be loved by me. b. for the moon never beams without bringing me dreams / of the beautiful annabel lee; c. that t...

### Rectangle ABCD has vertices at A(−3,1),B(−2,−1),C(2,1), and D(1,3). What is the area, in square

Rectangle ABCD has vertices at A(−3,1),B(−2,−1),C(2,1), and D(1,3). What is the area, in square units, of this rectangle? A 5 B 10 C 25 D 100...

### In what ways do macbeth's strengths contribute to his downfall?

In what ways do macbeth's strengths contribute to his downfall?...

### The Navy Pier Ferris Wheel in Chicago has a circumference that is ​56% of the circumference of the first Ferris wheel built in 1893.

The Navy Pier Ferris Wheel in Chicago has a circumference that is ​56% of the circumference of the first Ferris wheel built in 1893. the circumference of the Navy Pier Ferris Wheel is 439.6 ft. What was the radius of the first Ferris wheel? If someone could help me with this question it would be r...

### What is the [oh-] in a solution with a poh of 11.25

What is the [oh-] in a solution with a poh of 11.25...

### Can someone help me with my last question.

Can someone help me with my last question. $Can someone help me with my last question.$...

### Ian is a teacher and takes home 46 papers to grade over the weekend. He can grade at a rate of 11 papers per hour. Write a recursive

Ian is a teacher and takes home 46 papers to grade over the weekend. He can grade at a rate of 11 papers per hour. Write a recursive sequence to represent how many papers Ian has remaining to grade after working for n hours....

### Which type of macromolecule is made of amino acids

Which type of macromolecule is made of amino acids...

### Me with this question *if your in family and community service, me with these questions *

Me with this question *if your in family and community service, me with these questions * $Me with this question *if your in family and community service, me with these questions *$...

### Yokohama walks from home to buy stock at an average speed of 5 km/h humidity go on his school bus and traveled at an average speed

Yokohama walks from home to buy stock at an average speed of 5 km/h humidity go on his school bus and traveled at an average speed of 60 km/h until he got to school a total distance from his home to school is 35 km and the entire trip took a 1.5 hours...

### Am I doing this correctly getting answers of PowerPoint. Is the continent correct ?

Am I doing this correctly getting answers of PowerPoint. Is the continent correct ? $Am I doing this correctly getting answers of PowerPoint. Is the continent correct ?$...

### Part C: Balance each of the following equations following the procedure described in class. Be sure to show your work.

Part C: Balance each of the following equations following the procedure described in class. Be sure to show your work. $Part C: Balance each of the following equations following the procedure described in class. Be sure$...

### Why was Lincoln concerned he would not win re-election? (What were some of the criticisms of his decisions as president?) (Give at

Why was Lincoln concerned he would not win re-election? (What were some of the criticisms of his decisions as president?) (Give at least 3)...

### What is the molar mass of CH3OH

What is the molar mass of CH3OH...

### Derive the formula for the kinetic energy of an object of mass m, moving with velocity v​

Derive the formula for the kinetic energy of an object of mass m, moving with velocity v​...

### Look carefully at the face of an old person or a very young person. By studying the face, is there anythingyou can say about the person's character?

Look carefully at the face of an old person or a very young person. By studying the face, is there anything you can say about the person's character? What tells us whether a person is short-tempered, shy,playful, angry or happy?When you have made some points about the face, write a short descriptio...