I've been working on this multi-sheet, extra-credit homework assignment for a University Excel course and the first problem requires the creation of a complex retrieval function that contains a nested INDIRECT function.
I have created a function that achieves the end result, but I can't figure out how to utilize the INDIRECT function, I get errors every time I do.
Here's the complex retrieval function I created:
=IF(INDEX(IssueList,Reason,MATCH(Dept,Deps,0)+1)<>0,INDEX(IssueList,Reason,MATCH(Dept,Deps,0)+1),"")
And here is the assignment instruction:
In Issue column, enter a retrieval function that returns the issue from the table in the IssueList worksheet. Use an INDEX function that will use a nested INDIRECT reference to the Dept named range listed in column C, and use the Reason field in column B as the row number to return 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.
Any help will be much appreciated!
Bookmarks