Hi all,

I have a Vlookup which is returning some 0's and some N/A's (as it should).
i then have the following formulae:
=IF(ISNA(BZ15)*OR(BZ15="0"),IF((VLOOKUP($P15,Mapping!$C:$I,7,FALSE)="None"),CA$2,BZ15),BZ15)

But I'm not sure if that "0" here OR(BZ15="0") is the correct way to define the 0 being returned by the Vlookup.

I hope this is clear.

Thanks