VLOOKUP, if same data then nothing
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"))
|