Forum Discussion
Its_The_Rat
Jan 24, 2025Copper Contributor
#REF error; "not a valid cell/range reference" Help?
I was given a very broken Excel sheet that's supposed to calculate scores for our PT test (Army). There are errors everywhere. I know what the problem is, I don't know how to fix it. It should be a...
SergeiBaklan
Jan 25, 2025Diamond Contributor
MDL_F[[#Headers],[17]:[72]] returns some array of texts and INDIRECT doesn't work with arrays. For example
=INDIRECT( {"A1"} ) doesn't work, but
=INDIRECT( "A1" ) works.
Perhaps you may explain in more details what exactly you'd like to do, other ways to achieve result could exists.