COLUMN A IS 450 ITEM NUMBERS DEEP
COLUMN B IS A DESCRIPTIVE OF EACH
COLUMN C IS A CUSTOM NUMER (OUR INTERNAL) CORRESPONDING TO A
COLUMN D IS 9500 ITEM NUMBERS DEEP (MFR TOTAL PRODUCT LIST)
COLUMN E IS A DESCRIPTIVE OF EACH OF THE 9500
BURIED WITHIN THE 9500 IN NO PARTICULAR ORDER IS THE 450 FROM A
I WANT TO WRITE A MACRO/FORMULA TO SORT THROUGH ALL 9500 LOOKING FOR ONLY OUR ITEMS. WHERE THERE IS A MATCH, I WANT TO PASTE OUR NUMBER, IN AN AJOINING COLUMN.
ESSENTIALLY
IF WHERE A=D, THEN COPY C INTO COLUMN F.
REPEAT FOR ALL 450 ITEMS (AUTOMATICALLY)
COLUMN B IS A DESCRIPTIVE OF EACH
COLUMN C IS A CUSTOM NUMER (OUR INTERNAL) CORRESPONDING TO A
COLUMN D IS 9500 ITEM NUMBERS DEEP (MFR TOTAL PRODUCT LIST)
COLUMN E IS A DESCRIPTIVE OF EACH OF THE 9500
BURIED WITHIN THE 9500 IN NO PARTICULAR ORDER IS THE 450 FROM A
I WANT TO WRITE A MACRO/FORMULA TO SORT THROUGH ALL 9500 LOOKING FOR ONLY OUR ITEMS. WHERE THERE IS A MATCH, I WANT TO PASTE OUR NUMBER, IN AN AJOINING COLUMN.
ESSENTIALLY
IF WHERE A=D, THEN COPY C INTO COLUMN F.
REPEAT FOR ALL 450 ITEMS (AUTOMATICALLY)