IFERROR function with Array, Index, and Match combination function for Google Sheets

[CLS1986]

Hi - I'd like for the following function to return a blank cell rather than #n/a when there's no match, but I can't figure out how to make it work - any help would be greatly appreciated!
=ARRAY_CONSTRAIN(ARRAYFORMULA((INDEX('Schedule Information'!B:B,MATCH(B8,'Schedule Information'!D:D,0)))), 1, 1)

 

[zero269]

Hi CLS,

I don't have any Arrays to test with, but I do use the IFERROR Function in a few of my workbooks.

I basically just wrap the existing code inside the IFERROR function.

Without IFERROR:
AVERAGEIFS(tbl_Student1[Book Level],tbl_Student1[Test Date],[@[Test Date]])

With IFERROR:
=IFERROR(AVERAGEIFS(tbl_Student1[Book Level],tbl_Student1[Test Date],[@[Test Date]]),0)

IFERROR Syntax:
IFERROR(value, value_if_error)

In my example, I'm returning a 0 for the value_if_error.

Hope this helps...

 

[Peter_SSs]

Your profile says Office 365 but is this a Google Sheets question?

 

[CLS1986]

Thanks to you both for your response. I'm sorry, this is a google sheets question - I have Microsoft 365 but must use sheets for this application. I've tried wrapping the existing function within the iferror function, but only get a "Wrong number of arguments to ARRAY_CONSTRAIN. Expected 3 arguments, but got 2 arguments" #n/a response. Any ideas?

 

[Fluff]

I'm sorry, this is a google sheets question

In that case you should have clearly stated right from the start.
Also such questions should be posted in the General Discussion & Other Applications section of the board as it is not a Excel question.
I have done that for you this time.

 

[Fluff]

How about

=IFNA(INDEX('Schedule Information'!B:B,MATCH(B8,'Schedule Information'!D:D,0)),"")