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.
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.