Hello

I'm a bit confused as to how the IFERROR() formula would be able to correct my formula. If the formula is limited to only a singular array, is there any other way I can accomplish searching in multiple arrays? Thank you.