INDEX array problems!

[cardinal_steve]

Hi All

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

The working formula is..

[FONT=&quot]=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...[/FONT]

[FONT=&quot]=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!




It works with


[/FONT]

 

[Aladin Akyurek]

What is the range OCTOBER_2018 stands for? The same question regarding INVOICE_MONTH?

 

[cardinal_steve]

Hi. Thanks for your reply.

October_2018 is just a name for a range, let's say... A2:G30

INVOICE_MONTH is a cell which has the text October_2018 in it.

But the formula only works with October_2018 in it.

It's very frustrating.

 

[Aladin Akyurek]

Hi. Thanks for your reply.

October_2018 is just a name for a range, let's say... A2:G30

INVOICE_MONTH is a cell which has the text October_2018 in it.

But the formula only works with October_2018 in it.

It's very frustrating.

Try:

=COUNTIF(INDEX(INDIRECT(INVOICE_MONTH),MATCH(INVOICE_CHILD,Children,0),),"07:30")

 

[cardinal_steve]

Try:

=COUNTIF(INDEX(INDIRECT(INVOICE_MONTH),MATCH(INVOICE_CHILD,Children,0),),"07:30")

Aladin - That worked. You're a superstar. Thanks so much.

 

[Aladin Akyurek]

Aladin - That worked. You're a superstar. Thanks so much.

You are welcome.