INDEX Array problems

Hi All

I have a formula, that works! (Hooray!) But only with a manual entered INDEX array..

The working formula is..

=COUNTIF(INDEX(OCTOBER_2018,MATCH(INVOICE_CHILD,Children,0),),”07:30″) 

However I want it to be entered ‘on the fly’ and when it is the following…

=COUNTIF(INDEX(INVOICE_MONTH,MATCH(INVOICE_CHILD,Children,0),),”07:30″)

…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!

By: Steve

Leave a Reply

Your email address will not be published. Required fields are marked *