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))
=INDEX(INDIRECT($F$2),MATCH(G1,movie,0))From your screenshot i can't tell what you exactly want to do. However it's possible to combine INDEX and MATCH with INDIRECT and to drag the formula across a range.
When I use that formula I get an error, did I not correctly type it in? I need to use the INDIRECT function to return a reference to a text string and my prof said I am not returning a Movie Name by referencing cell M5. The MATCH function should be looking for the maximum value in the list. Screenshot given below is the entire table with no filteres.