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
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started