My Index function won't resolve in Excel 365. I want the function to return the value at an interesecton of a row or column of a pre-defined array which I have also setup as a named Range. The syntax I am typing is: =INDEX(Db1_Pageviews|$C$7|C$8). here, C7 gives the row number and C8 the column number. Why is Excel not resolving this?
Solved by E. A. in 16 mins