IFNA - Array formula

[scubadiver007]

Hi,

I have the following formula. The array covers a number of rows some of which return #N/A even if I include the error.

{=IFNA(OFFSET($F$1,MATCH($B$8,$D$2:$D$9,0),,$B$6),"")}

Is it possible to get it to return an empty string?

Thanks

[bebo021999]

Just guess:
=IFNA(OR(ISERROR(OFFSET($F$1,MATCH($B$8,$D$2:$D$9,0),,$B$6))),"")

Note: OFFSET returns a range. ISERROR(OFFSET...) to turn error into TRUE
OR(...) returns TRUE if there is one error occur at least.

[scubadiver007]

It occurred to me I can do an IFERROR formula in the adjacent column!