Hi all. I was wondering how to error trap inported data
that uses one column as a lookup. i.e., that column has
imported part numbers and the column next to it looks up a
discription for that part number in another worksheet and
displays it next to the imported part number. The problem
is if the part number and discription is not in the lookup
table, the cell unfortunately reverts to the previous cell
in the lookup table and displays it. It does not show an
error or something to indicate no match for that cell part
number in the discription cell. Any solutions?