Array formula #VALUE error

[Finalfight40]

Hi All

I am creating a formula but am having an issue which im not sure how to correct.

My formula is below:

=TEXTJOIN(", ", TRUE, IF(((MONTH(A1) >= MONTH(Sheet1!B2:B26)) * (MONTH(A1) <= MONTH(Sheet1!C2:C26)) + ((MONTH(A1) >= MONTH(Sheet1!D2:D26)) * (MONTH(A1) <= MONTH(Sheet1!E2:E26)))), ROW(Sheet1!A2:A26), ""))

When i evaluate the formula i am getting #VALUE for this part of the formula:

(MONTH(A1) <= MONTH(Sheet1!E2:E26))

I believe this is because there is a formula in cells Sheet1!E2:E26 which returns "".

This formula is an array.

Thanks

 

[Legacy 436357]

How about?

{=IFERROR(TEXTJOIN(", ", TRUE, IF(((MONTH(A1) >= MONTH(Sheet1!B2:B26)) * (MONTH(A1) <= MONTH(Sheet1!C2:C26)) + ((MONTH(A1) >= MONTH(Sheet1!D2:D26)) * (MONTH(A1) <= MONTH(Sheet1!E2:E26)))), ROW(Sheet1!A2:A26), "")),””)}

 

[Aladin Akyurek]

Looks like: Control+shift+enter, not just enter...

=TEXTJOIN(", ", TRUE, IF(1-ISERROR(((MONTH(A1) >= MONTH(Sheet1!B2:B26)) * (MONTH(A1) <= MONTH(Sheet1!C2:C26)) + ((MONTH(A1) >= MONTH(Sheet1!D2:D26)) * (MONTH(A1) <= MONTH(Sheet1!E2:E26))))), ROW(Sheet1!A2:A26), ""))

 

[Finalfight40]

Perfect.

Thank you both for your help.

 

[Aladin Akyurek]

You are welcome.