Thanks Glenn. Odd though as the format of cell G39 is general and so is the source data. I am not clear how to add this zero to =IF(ISNA(VLOOKUP($G$29,B620_CPS,6,)),"",VLOOKUP($G$29,B620_CPS,6,)) or to what? Thanks!