N
nastech
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 are: (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"))
use to make item equal nothing if the data is the same in both sheets.
samples have are: (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"))