Spreadsheet: 221057d1363357797-using-trim-in-the-second-parameter-of-a-vlookup-excelforumupload
Sheet: Testing

[NAME] | QTY ORDR |  | Lenth
1001364-00-A-810 | 30000 |  | 27
1002932-00-A-810 | 10000 |  | 27
1003744-00-A-810 | 5000 |  | 27
1006147-00-A-810 | 15000 |  | 27
1006585-00-A-810 | 144000 |  | 27
1006587-00-A-810 | 30000 |  | 27
1009304-00-A-810 | 30000 |  | 27
1009575-00-A-810 | 25000 |  | 27
1009765-00-A-810 | 10000 |  | 27
1009771-00-A-810 | 6500 |  | 27
1009801-00-A-810 | 8000 |  | 27
1009887-00-A-810 | 30000 |  | 27
1009990-00-A-810 | 10000 |  | 27
1010000-00-A-810 | 8000 |  | 27
1010028-00-A-810 | 5000 |  | 27
1010250-00-A-810 | 10000 |  | 27
1010292-00-A-810 | 15000 |  | 27
1010382-00-A-810 | 50000 |  | 27
1010874-00-A-810 | 35000 |  | 27
1010892-00-A-810 | 12000 |  | 27
1009073-00-A-810 | 1152 |  | 27
1009772-00-A-810 | 16000 |  | 27
1010864-00-A-810 | 40000 |  | 27
1010865-00-A-810 | 4000 |  | 27
1012884-00-A-810 | 1000 |  | 27
1012888-00-A-810 | 3910 |  | 27
1018360-00-A-810 | 24000 |  | 27
2005438-810 | 10000 |  | 27
2005710-810 | 6000 |  | 27
2005808-810 | 12000 |  | 27
2000456-810 | 30000 |  | 27
2004475-810 | 50000 |  | 27
2005184-810 | 22500 |  | 27
2005187-810 | 40000 |  | 27
2005380-810 | 15000 |  | 27
2005408-810 | 48000 |  | 27
2006210-810 | 10000 |  | 27
2006211-810 | 10000 |  | 27
2006214-810 | 10000 |  | 27
2006215-810 | 10000 |  | 27
2006231-810 | 80000 |  | 27
2006236-810 | 40000 |  | 27
2006238-810 | 30000 |  | 27
2006240-810 | 140000 |  | 27
2006248-810 | 10000 |  | 27
2006252-810 | 15000 |  | 27
2006253-810 | 8000 |  | 27
2006282-810 | 10000 |  | 27
2006298-810 | 80000 |  | 27
2007863-810 | 5400 |  | 27
2007867-810 | 2000 |  | 27
2007869-810 | 30000 |  | 27
2007873-810 | 30000 |  | 27
2007874-810 | 10000 |  | 27
2007877-810 | 1500 |  | 27
2007882-810 | 20000 |  | 27
2007883-810 | 60000 |  | 27
2007921-810 | 10000 |  | 27
2007922-810 | 20000 |  | 27
2007941-810 | 170000 |  | 27
2007943-810 | 40000 |  | 27
2007950-810 | 15000 |  | 27
2007956-810 | 50000 |  | 27
2007963-810 | 10000 |  | 27
2007984-810 | 40000 |  | 27
2007960-810 | 10000 |  | 27
2007985-810 | 10000 |  | 27
2007992-810 | 170000 |  | 27
2008003-810 | 4000 |  | 27
2008009-810 | 10000 |  | 27
2008016-810 | 10000 |  | 27
2008018-810 | 10000 |  | 27
2008028-810 | 30000 |  | 27
2008037-810 | 100000 |  | 27
2008070-810 | 10000 |  | 27
2008073-810 | 30000 |  | 27
2008083-810 | 70000 |  | 27
2008092-810 | 20000 |  | 27
2008093-810 | 200000 |  | 27
2008094-810 | 10000 |  | 27
2008109-810 | 10000 |  | 27
2008114-810 | 5000 |  | 27
2008115-810 | 10000 |  | 27
2008023-810 | 80000 |  | 27
2008024-810 | 10000 |  | 27
2008025-810 | 30000 |  | 27
2007923-810 | 2000 |  | 27
2007965-810 | 20000 |  | 27
2008001-810 | 1800 |  | 27
2008107-810 | 3600 |  | 27
1009069-00-A-810 | 500 |  | 27
2005397-810 | 15000 |  | 27
2006227-810 | 20000 |  | 27
1006583-00-A-810 | 12000 |  | 27
2008036-810 | 4000 |  | 27
2006343-810 | 12000 |  | 27
2008019-810 | 15000 |  | 27
1017856-00-A-810 | 30000 |  | 27
2007904-810 | 4000 |  | 27
2007801-810 | 35000 |  | 27
1011394-00-A-810 | 190000 |  | 27
2006722-810 | 10000 |  | 27
2008011-810 | 2000 |  | 27
2007822-810 | 25000 |  | 27
2007824-810 | 15000 |  | 27
1011384-00-A-810 | 3000 |  | 27
1011581-00-A-810 | 25000 |  | 27
2008124-810 | 9000 |  | 27
1018434-00-A-810 | 4000 |  | 27
2007846-810 | 4000 |  | 27
1011535-00-A-810 | 1000 |  | 27
2007886-810 | 50000 |  | 27
2007977-810 | 2000 |  | 27
2008013-810 | 2000 |  | 27
1015447-00-A-810 | 4000 |  | 27
1019426-00-A-810 | 10000 |  | 27
1003293-00-A-810 | 5000 |  | 27
1003299-00-A-810 | 5000 |  | 27
1003300-00-A-810 | 5000 |  | 27
1003301-00-A-810 | 5000 |  | 27
1004957-00-A-810 | 5000 |  | 27
2007315-810 | 5000 |  | 27
2004531-810 | 5000 |  | 27
2005200-810 | 6000 |  | 27
2006294-810 | 5000 |  | 27
2006747-810 | 5000 |  | 27
2007821-810 | 55000 |  | 27
1003234-00-A-810 | 10000 |  | 27
1004337-00-A-810 | 2000 |  | 27
1003476-00-A-810 | 10000 |  | 27
1021066-00-A-810 | 2000 |  | 27
2008012-810 | 10000 |  | 27
1012721-00-A-810 | 2500 |  | 27
1012722-00-A-810 | 4000 |  | 27
1004720-00-A-810 | 2000 |  | 27
1005657-00-A-810 | 500 |  | 27
1007204-00-A-810 | 3000 |  | 27
1010936-00-A-810 | 3000 |  | 27
2001046-810 | 12000 |  | 27
1013203-00-A-810 | 5000 |  | 27
2007715-810 | 1000 |  | 27
1011741-00-A-810 | 2478 |  | 27
2005645-810 | 12000 |  | 27
1005656-00-A-810 | 10000 |  | 27
2007831-810 | 10000 |  | 27
2007833-810 | 25000 |  | 27
1019520-00-A-810 | 8000 |  | 27
2001135-810 | 5500 |  | 27
1004816-00-A-810 | 8000 |  | 27
1009663-00-A-810 | 6300 |  | 27
1003298-00-A-810 | 5000 |  | 27
1011397-00-A-810 | 10000 |  | 27
2006716-810 | 10000 |  | 27
2006724-810 | 10000 |  | 27
2006743-810 | 10000 |  | 27
2007842-810 | 10000 |  | 27
2007850-810 | 10000 |  | 27
1009079-00-A-810 | 4000 |  | 27
2007881-810 | 10000 |  | 27
2005864-810 | 60000 |  | 27
2007242-810 | 2000 |  | 27
2007871-810 | 90000 |  | 27
1021172-00-A-810 | 210 |  | 27
2006732-810 | 5000 |  | 27
1018684-00-A-810 | 4000 |  | 27
1016191-00-A-810 | 10000 |  | 27
1005658-00-A-810 | 10000 |  | 27
2008101-810 | 500 |  | 27
1019592-00-A-810 | 2000 |  | 27