How to get rid of extracted cells displaying "0"

Originally Posted by abousetta

If the first formula worked fine then this should work also:

Formula:

=If(ISNA(IF(or(ISNA(VLOOKUP($B21,'Season Results History (Hidden)'!$B:$Y,11,0)),VLOOKUP($B21,'Season Results History (Hidden)'!$B:$Y,11,0)=""),"",VLOOKUP($B21,'Season Results History (Hidden)'!$B:$Y,11,0))),"",IF(or(ISNA(VLOOKUP($B21,'Season Results History (Hidden)'!$B:$Y,11,0)),VLOOKUP($B21,'Season Results History (Hidden)'!$B:$Y,11,0)=""),"",VLOOKUP($B21,'Season Results History (Hidden)'!$B:$Y,11,0)))

That worked fine. Thanks.