Ignore blanks in dynamic list?

[Camel123]

Hi,

The formula below,

{=IFERROR(IF(INDEX(Distributed_costs!$V$2:$V$22222;MATCH(0;COUNTIF(General_data!$C$2:C2;Distributed_costs!$V$2:$V$22222);0))=0;"";INDEX(Distributed_costs!$V$2:$V$22222;MATCH(0;COUNTIF(General_data!$C$2:C2;Distributed_costs!$V$2:$V$22222);0)));"")}

Returns a blank value as the referenced range contains formulas returning "" in some cases. I tried using google to come around this issue but could not manage to. Anyone who could help me out and explain as well?

Thanks.

 

[Camel123]

Anyone? ?