Forum Discussion
Solved
Index function with Indirect function within
Hello, I am new to excel goin to college for it and Im struggling with a problem. I need to create a formula In cell N5, enter an INDEX function that will retrieve the name of the movie with the high...
Place in N5 and fill across:
=INDEX(Table1,MATCH(MAX(Table1[[Gross]:[Gross]]),Table1[[Gross]:[Gross]],0),MATCH(N4,Table1[#Headers],0))
Are you trying to return the highest grossing movie/genre/company based on the filtered selection?
yes i think so. The end result should look like this:
Thank you for your help btw, much appreciated
Place in N5 and fill across:
=INDEX(Table1,MATCH(MAX(Table1[[Gross]:[Gross]]),Table1[[Gross]:[Gross]],0),MATCH(N4,Table1[#Headers],0))- omg thank you broski if you wouldnt mind could you explain how this works, so next time I can do it on my own? Again youre a king thanks