subject

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
Answers: 2

Other questions on the subject: Computers and Technology

image
Computers and Technology, 21.06.2019 17:00, naomicervero
Which process would best represent the opposite of exhausting air from a system?
Answers: 2
image
Computers and Technology, 23.06.2019 16:30, rileysndr1782
Monica and her team have implemented is successfully in an organization. what factor leads to successful is implementation? good between different departments in an organization leads to successful is implementation.
Answers: 1
image
Computers and Technology, 23.06.2019 22:20, kandi2565
What is a programming method that provides for interactive modules to a website?
Answers: 1
image
Computers and Technology, 23.06.2019 22:50, atifgujar
An environmental protection agency study of 12 automobiles revealed a correlation of 0.47 between engine size and emissions. at 0.01 significance level, can we conclude that there is a positive association between the variables? what is the p value? interpret.
Answers: 2
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...

Questions in other subjects:

Konu
Mathematics, 05.05.2020 07:05
Konu
History, 05.05.2020 07:05
Konu
Mathematics, 05.05.2020 07:05