hi, have couple of samples of VLOOKUP using, cannot quite figure out what to
use to make item equal nothing if the data is the same in both sheets.
samples have a (cntrl-shift-enter array formula) thanks

=IF(OR(AQ7={"","."},ISNA(VLOOKUP(AQ7,[file.xls]sheet!$AP$1:$CI$3355,(COLUMN(CI1)-COLUMN(AP1))+1,FALSE))),"",VLOOKUP(AQ7,[file.xls]sheet!$AP$1:$CI$3355,(COLUMN(CI1)-COLUMN(AP1))+1,FALSE))

=IF(OR(AQ9={"","."}),"",IF(ISNA(VLOOKUP(AQ9,[file.xls]sheet!$AP$1:$AP$3355,1,0)),"dif","dup"))