K
Kris K
First make sure you use a trim formula on the AS400
dowload data (for the part #'s)
=trim(X)
X=the cell with part number. Then compare the part #'s and
do the if stmt. You shouldn't get an error on a simple if
then stmt if it's formated the same. You may have to do
the same trim on the old data.
dowload data (for the part #'s)
=trim(X)
X=the cell with part number. Then compare the part #'s and
do the if stmt. You shouldn't get an error on a simple if
then stmt if it's formated the same. You may have to do
the same trim on the old data.