Spreadsheet: 27093d1219940697-lookup-index-and-or-match-excel-forum-macro-example
Sheet: Messages

Customer No.-No. |  | MSG No. | Text | Print on Sales Order | Print on Sales Invoice | Print on Delivery Ticket | Print on Pick/Pull List | Print on Cut List | Print on Printed BOM | Print on All Documents | Created By | Created Date | Created Time | Updated By | Updated Date | Updated Time | Document No | Language Code | Text No.
421009-1 | PHMI01-0001 | 1 | SEND DROP | Yes | No | Yes | No | Yes | Yes | No |  |  |  |  |  |  |  |  | 1
421009-1 | PHMI01-0001 | 2 | ** MUST BE 20 PCS / BDL  *** | Yes | Yes | Yes | Yes | No | Yes | No | DEBBIES | 2004-02-18 00:00:00 | 7:39:07 AM | PETES | 2006-06-28 00:00:00 | 9:57:49 AM |  |  | 1
421009-1 | PHMI01-0001 | 3 | ** CUT FROM 10' , SEND DROP ** | Yes | No | Yes | Yes | Yes | Yes | No | DEBBIES | 2006-08-21 00:00:00 | 12:32:35 | DEBBIES | 2006-08-21 00:00:00 | 12:32:54 |  |  | 1
421009-2 | PHMI01-0002 | 1 | 9 PCS/ BDL | No | No | No | Yes | No | No | No |  |  |  | DEBBIES | 2006-07-25 00:00:00 | 12:24:23 |  |  | 1
421009-6 | PHMI01-0006 | 1 | CUT 4 V'S PER PRINT | No | No | No | No | No | Yes | No |  |  |  |  |  |  |  |  | 1
421009-6 | PHMI01-0006 | 2 | **PAINT ONE END YELLOW** | No | No | No | No | No | Yes | No | KIMW | 2007-03-13 00:00:00 | 4:38:32 PM | KIMW | 2007-03-13 00:00:00 | 4:38:37 PM |  |  | 1
421009-10 | PHMI01-0010 | 1 | PLEASE MAKE SURE MAT'L IS SOUND QUALITY *** | No | No | No | Yes | Yes | Yes | No | DEBBIES | 2003-10-02 00:00:00 | 10:40:00 |  |  |  |  |  | 1
421009-10 | PHMI01-0010 | 2 | 75 PCS /BDL | No | No | No | No | No | Yes | No | DEBBIES | 2006-04-06 00:00:00 | 1:27:37 PM | DEBBIES | 2006-06-16 00:00:00 | 7:18:14 AM |  |  | 1
421009-11 | PHMI01-0011 | 1 | STAMP HT FOR EURO-SHIP | No | No | No | No | No | Yes | No |  |  |  |  |  |  |  |  | 1
421009-12 | PHMI01-0012 | 1 | STAMP HT FOR EURO-SHIP | No | No | No | No | Yes | Yes | No |  |  |  |  |  |  |  |  | 1
421009-12 | PHMI01-0012 | 2 | MARK BOX WITH P/N IF APPLICABLE | No | No | No | No | No | Yes | No |  |  |  |  |  |  |  |  | 1
421009-12 | PHMI01-0012 | 3 | DESCRIPTION & DIMENSIONS (I.D.) | No | No | No | No | No | Yes | No |  |  |  |  |  |  |  |  | 1
421009-12 | PHMI01-0012 | 4 | A.D.72 X 24-3/4 X 24 | No | No | No | No | No | Yes | No | JOHNJ | 2003-12-11 00:00:00 | 1:00:24 PM | JOHNJ | 2003-12-11 00:00:00 | 1:00:28 PM |  |  | 1
421009-13 | PHMI01-0013 | 1 | STAMP HT  FOR EURO-SHIP | No | No | No | No | No | Yes | No |  |  |  |  |  |  |  |  | 1
421009-13 | PHMI01-0013 | 2 | A.D.64 X 64 X 40-1/2 | No | No | No | No | No | Yes | No | JOHNJ | 2003-12-11 00:00:00 | 1:01:27 PM | JOHNJ | 2003-12-11 00:00:00 | 1:01:29 PM |  |  | 1
421009-14 | PHMI01-0014 | 1 | STAMP FOR EURO-SHIP | No | No | No | No | No | Yes | No |  |  |  |  |  |  |  |  | 1
421009-14 | PHMI01-0014 | 2 | 162 X 19.5 X 20.5 | No | No | No | No | No | Yes | No | JOHNJ | 2003-12-11 00:00:00 | 1:01:55 PM | JOHNJ | 2003-12-11 00:00:00 | 1:01:56 PM |  |  | 1
421009-15 | PHMI01-0015 | 1 | HT STAMP FOR EURO-SHIP | No | No | No | No | No | Yes | No |  |  |  |  |  |  |  |  | 1
421009-16 | PHMI01-0016 | 1 | stamp for euro-ship | No | No | No | No | No | Yes | No |  |  |  |  |  |  |  |  | 1
421009-16 | PHMI01-0016 | 2 | A.D.95 x 95 x 18.5 | No | No | No | No | No | Yes | No | JOHNJ | 2003-12-11 00:00:00 | 1:02:48 PM | JOHNJ | 2003-12-11 00:00:00 | 1:02:50 PM |  |  | 1
421009-17 | PHMI01-0017 | 1 | STAMP FOR EURO-SHIP | No | No | No | No | No | Yes | No |  |  |  |  |  |  |  |  | 1
421009-17 | PHMI01-0017 | 2 | TAG: 2-DW | No | No | No | No | No | Yes | No |  |  |  |  |  |  |  |  | 1
421009-18 | PHMI01-0018 | 1 | STAMP FOR EURO-SHIP | No | No | No | No | No | Yes | No |  |  |  | DAVES | 2003-07-08 00:00:00 | 8:12:07 AM |  |  | 1
421009-18 | PHMI01-0018 | 2 | TAG: 2-CW | No | No | No | No | No | Yes | No |  |  |  | DAVES | 2003-07-08 00:00:00 | 8:12:52 AM |  |  | 1
421009-18 | PHMI01-0018 | 3 | 3R X2H | No | No | No | No | No | Yes | No | [NAME] | 2007-09-12 00:00:00 | 10:37:56 | [NAME] | 2007-09-12 00:00:00 | 10:37:57 |  |  | 1
421009-19 | PHMI01-0019 | 1 | HT STAMP | No | No | No | Yes | Yes | Yes | No |  |  |  |  |  |  |  |  | 1
421009-19 | PHMI01-0019 | 2 | A.D.206 X 19.5 X 20.5 2YW (OR) | No | No | No | No | No | Yes | No |  |  |  | JOHNJ | 2003-12-11 00:00:00 | 1:03:33 PM |  |  | 1
421009-20 | PHMI01-0020 | 1 | STAMP FOR EURO-SHIP | No | No | No | No | No | Yes | No |  |  |  |  |  |  |  |  | 1
421009-20 | PHMI01-0020 | 2 | A.D. 130 X 19.5 X 20.5 | No | No | No | No | No | Yes | No | JOHNJ | 2003-12-11 00:00:00 | 2:50:56 PM | JOHNJ | 2003-12-11 00:00:00 | 2:50:58 PM |  |  | 1