Wow, such a stupid mistake!!
Thanks so much. I had intended the array to go to $AX$501, just a typo!
Thanks again.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>
> Hey,
>
The Error you are getting is just because the defined array is not Correct
in INDEX,Let me Explain it to you Why !!
Indirect Syntax is =INDEX(Array,Rownum,Column)
For example you want to go two rows down and 2 columns wide then formula
would be = index(A1:D10,2rows down,3columns