I have a formula, that works! (Hooray!) But only with a manual entered INDEX array..
The working formula is..
However I want it to be entered ‘on the fly’ and when it is the following…
…I get a REF error but only with the INVOICE_MONTH
Basically, I have a drop down list (named INVOICE_MONTH) that I want to change for every month (!) but if INVOICE MONTH contains e.g OCTOBER_2018 it errors.
Is there anyway to be able to used a named array via text from elsewhere? INVOICE_CHILD works in the same work, but works!
Thanks in advance!