What's causing this #NA error ? am using VSTACK and FILTER

[shili12]

Apologies for not posting xlsx workbook as should be the norm, but i suppose the formula thru observation can be resolved, if not i will try to eliminate sensitive data and upload xlsx workbook
column A column B column C column D


the formula used in column b1 is
=VSTACK(FILTER('1stfebtill31stdec2021'!$A$2:$G$134137,ISNUMBER(SEARCH($A1,'1stfebtill31stdec2021'!$E$2:$E$134137)),"??"),FILTER('1stjantill31stdec2020'!$A$2:$G$84468,ISNUMBER(SEARCH($A1,'1stjantill31stdec2020'!$E$2:$E$84468)),"??"))

worksheets are named as '1stfebtill31stdec2021' and '1stjantill31stdec2020',
$A1 is kmfr111T

in column b2, ?? is ok but why are rest of those reflecting #N/A and how do i resolve it ?

 

[Debaser]

If either FILTER function returns no results, they return a single ?? value, not an array of those values. VSTACK returns #N/A for any missing values. You should wrap that in IFERROR to replace them.

 

[shili12]

doesnt work out still
=VSTACK(IFERROR(FILTER('1stfebtill31stdec2021'!$A$2:$G$134137,ISNUMBER(SEARCH($A1, '1stfebtill31stdec2021'!$E$2:$E$134137))),""),IFERROR(FILTER('1stjantill31stdec2020'!$A$2:$G$84468,ISNUMBER(SEARCH($A1, '1stjantill31stdec2020'!$E$2:$E$84468)),""),""))

 

[shili12]

or even if i place back => "??"
=VSTACK(IFERROR(FILTER('1stfebtill31stdec2021'!$A$2:$G$134137,ISNUMBER(SEARCH($A1, '1stfebtill31stdec2021'!$E$2:$E$134137)),"??"),""),IFERROR(FILTER('1stjantill31stdec2020'!$A$2:$G$84468,ISNUMBER(SEARCH($A1, '1stjantill31stdec2020'!$E$2:$E$84468)),"??"),""))

 

[Debaser]

You need to wrap the VSTACK in IFERROR, not have the IFERROR inside the VSTACK (since the FILTER functions are not returning any errors).

For example:
=IFERROR(VSTACK(FILTER('1stfebtill31stdec2021'!$A$2:$G$134137,ISNUMBER(SEARCH($A1,'1stfebtill31stdec2021'!$E$2:$E$134137)),"??"),FILTER('1stjantill31stdec2020'!$A$2:$G$84468,ISNUMBER(SEARCH($A1,'1stjantill31stdec2020'!$E$2:$E$84468)),"??")),"??")

 

[shili12]

Thanks, i got it now:-
=IFERROR(VSTACK(FILTER('1stfebtill31stdec2021'!$A$2:$G$134137,ISNUMBER(SEARCH($A1, '1stfebtill31stdec2021'!$E$2:$E$134137)),"??"),FILTER('1stjantill31stdec2020'!$A$2:$G$84468,ISNUMBER(SEARCH($A1, '1stjantill31stdec2020'!$E$2:$E$84468)),"??")),"??")