![subject](/tpl/images/cats/informatica.png)
Computers and Technology, 21.04.2020 19:31 BFBtrent
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.
![ansver](/tpl/images/cats/User.png)
Answers: 2
![](/tpl/images/ask_question.png)
![](/tpl/images/ask_question_mob.png)
Other questions on the subject: Computers and Technology
![image](/tpl/images/cats/informatica.png)
Computers and Technology, 21.06.2019 21:00, calmicaela12s
The mode is generally used when delivering a presentation to an need now
Answers: 1
![image](/tpl/images/cats/informatica.png)
Computers and Technology, 21.06.2019 22:00, taniyahreggienae
What is the most important aspect of marking media? a. data labelingb. content descriptionc. electronic labelingd. classification
Answers: 2
![image](/tpl/images/cats/informatica.png)
You know the right answer?
I have been trying to work on this for a while now, and this is on excel
In cell H10, en...
In cell H10, en...
Questions in other subjects:
![Konu](/tpl/images/cats/biologiya.png)
![Konu](/tpl/images/cats/biologiya.png)
![Konu](/tpl/images/cats/mat.png)
![Konu](/tpl/images/cats/mat.png)
![Konu](/tpl/images/cats/biologiya.png)
![Konu](/tpl/images/cats/obshestvoznanie.png)
Social Studies, 09.07.2019 11:30
![Konu](/tpl/images/cats/himiya.png)
![Konu](/tpl/images/cats/health.png)
Health, 09.07.2019 11:30
![Konu](/tpl/images/cats/biologiya.png)
![Konu](/tpl/images/cats/mat.png)
Mathematics, 09.07.2019 11:30