"nastech" wrote in message
...


=IF(OR(V244={"",".",".sym."}),"",IF(ISNA(VLOOKUP(V 1,[file.xls]sheet!$A$1:$A$
3355,1,0)),"dif",""))

You don't need the OR, as there is only a single condition, even though it
is testing two values.