shahid5788
Board Regular
- Joined
- May 24, 2016
- Messages
- 91
Hi,
I have 2 work sheets in which I need to extract which employee works on which customer. The common denominator for both worksheets is "Account#" in which I can do a Vlookup but it still does not really help since couple customer belong to multiple employees.
Each employee has their own invoice number convention. (Mark="Inv2016"), (Amy="02-"), Eric ("INV").
Can someone please assist on which formula will help to extract the correct employee working to their particular project?
Sheet 1
[TABLE="width: 1105"]
<colgroup><col><col><col><col><col><col><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD]Customer Name[/TD]
[TD]Account #[/TD]
[TD]Invoice Number[/TD]
[TD]Invoice Date[/TD]
[TD]Invoice Amount[/TD]
[TD]Due Date[/TD]
[TD]Current[/TD]
[TD]31 to 60[/TD]
[TD]61 to 90[/TD]
[TD]Over 90[/TD]
[TD]Balance Due[/TD]
[/TR]
[TR]
[TD]American Airlines[/TD]
[TD]1105[/TD]
[TD]INV15-11230[/TD]
[TD]10/31/15[/TD]
[TD]5,405.00[/TD]
[TD]12/15/15[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]5,405.00[/TD]
[TD]5,405.00[/TD]
[/TR]
[TR]
[TD]Applied Materials[/TD]
[TD]1102[/TD]
[TD]INV16-11425[/TD]
[TD]01/31/16[/TD]
[TD]337.50[/TD]
[TD]03/31/16[/TD]
[TD]0.00[/TD]
[TD]337.50[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]337.50[/TD]
[/TR]
[TR]
[TD]Applied Materials GmbH [/TD]
[TD]1101[/TD]
[TD]INV16-11483[/TD]
[TD]02/29/16[/TD]
[TD]30,546.20[/TD]
[TD]04/29/16[/TD]
[TD]30,546.20[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]30,546.20[/TD]
[/TR]
[TR]
[TD]Applied Materials SE Asia[/TD]
[TD]1149[/TD]
[TD]INV16-11532[/TD]
[TD]03/31/16[/TD]
[TD]892.00[/TD]
[TD]05/30/16[/TD]
[TD]892.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]892.00[/TD]
[/TR]
[TR]
[TD]BIS[/TD]
[TD]1193[/TD]
[TD]02-7170[/TD]
[TD]03/31/16[/TD]
[TD]96,325.64[/TD]
[TD]04/30/16[/TD]
[TD]96,325.64[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]96,325.64[/TD]
[/TR]
[TR]
[TD]Boeing[/TD]
[TD]1067[/TD]
[TD]02-7014R[/TD]
[TD]11/30/15[/TD]
[TD]2,400.00[/TD]
[TD]01/14/16[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](1,680.00)[/TD]
[TD](1,680.00)[/TD]
[/TR]
[TR]
[TD]Boston Capital[/TD]
[TD]1196[/TD]
[TD]02-7230[/TD]
[TD]04/30/16[/TD]
[TD]8,775.00[/TD]
[TD]05/30/16[/TD]
[TD]8,775.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]8,775.00[/TD]
[/TR]
[TR]
[TD]CDO Technologies, Inc[/TD]
[TD]1110[/TD]
[TD]I14-5018[/TD]
[TD]06/06/14[/TD]
[TD]1,893.10[/TD]
[TD]07/06/14[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]1,893.10[/TD]
[TD]1,893.10[/TD]
[/TR]
[TR]
[TD]Collier County School[/TD]
[TD]11203[/TD]
[TD]02-7215[/TD]
[TD]04/30/16[/TD]
[TD]199.00[/TD]
[TD]05/30/16[/TD]
[TD]199.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]199.00[/TD]
[/TR]
[TR]
[TD]Concentra[/TD]
[TD]1152[/TD]
[TD]02-7198[/TD]
[TD]04/30/16[/TD]
[TD]105,700.00[/TD]
[TD]05/30/16[/TD]
[TD]105,700.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]105,700.00[/TD]
[/TR]
[TR]
[TD]Delta Air Lines, Inc[/TD]
[TD]1112[/TD]
[TD]INV2016-0045[/TD]
[TD]04/13/16[/TD]
[TD]4,375.00[/TD]
[TD]05/28/16[/TD]
[TD]4,375.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]4,375.00[/TD]
[/TR]
[TR]
[TD]DTE Gas Company [/TD]
[TD]1209[/TD]
[TD]02-7186[/TD]
[TD]03/31/16[/TD]
[TD]24,453.00[/TD]
[TD]04/30/16[/TD]
[TD]24,453.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]24,453.00[/TD]
[/TR]
[TR]
[TD]Eaton Vance Management[/TD]
[TD]1202[/TD]
[TD]02-7213[/TD]
[TD]04/30/16[/TD]
[TD]2,940.00[/TD]
[TD]05/30/16[/TD]
[TD]2,940.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]2,940.00[/TD]
[/TR]
[TR]
[TD]Editions Francis Lefebvre[/TD]
[TD]1116[/TD]
[TD]02-7155[/TD]
[TD]03/30/16[/TD]
[TD]56,500.00[/TD]
[TD]05/14/16[/TD]
[TD]56,500.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]56,500.00[/TD]
[/TR]
[TR]
[TD]EMC USA[/TD]
[TD]1003[/TD]
[TD]02-6917[/TD]
[TD]09/30/15[/TD]
[TD]30,750.00[/TD]
[TD]11/29/15[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]30,750.00[/TD]
[TD]30,750.00[/TD]
[/TR]
[TR]
[TD]EMS Aviation Inc[/TD]
[TD]1117[/TD]
[TD]INV16-11466[/TD]
[TD]01/31/16[/TD]
[TD]1,372.00[/TD]
[TD]04/30/16[/TD]
[TD]1,372.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]1,372.00[/TD]
[/TR]
[TR]
[TD]General Electric Company[/TD]
[TD]1123[/TD]
[TD]02-7232[/TD]
[TD]04/30/16[/TD]
[TD]15,404.24[/TD]
[TD]08/28/16[/TD]
[TD]15,404.24[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]15,404.24[/TD]
[/TR]
[TR]
[TD]Honeywell[/TD]
[TD]1124[/TD]
[TD]13-10073[/TD]
[TD]10/31/13[/TD]
[TD]15,090.00[/TD]
[TD]01/29/14[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[/TR]
[TR]
[TD]Korry Electronics [/TD]
[TD]1129[/TD]
[TD]13-10087[/TD]
[TD]10/31/13[/TD]
[TD]76,265.40[/TD]
[TD]11/30/13[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]177.75[/TD]
[TD]177.75[/TD]
[/TR]
[TR]
[TD]Malaysia Airlines[/TD]
[TD]1130[/TD]
[TD]2012-0141[/TD]
[TD]06/01/12[/TD]
[TD]9,362.50[/TD]
[TD]07/01/12[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]9,362.50[/TD]
[TD]9,362.50[/TD]
[/TR]
[TR]
[TD]McGraw Hill[/TD]
[TD]1005[/TD]
[TD]02-7154[/TD]
[TD]03/29/16[/TD]
[TD]215,888.75[/TD]
[TD]05/13/16[/TD]
[TD]215,888.75[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]215,888.75[/TD]
[/TR]
[TR]
[TD]Medicinova[/TD]
[TD]1219[/TD]
[TD]02-7107[/TD]
[TD]02/23/16[/TD]
[TD]6,053.85[/TD]
[TD]03/24/16[/TD]
[TD]0.00[/TD]
[TD]6,053.85[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]6,053.85[/TD]
[/TR]
[TR]
[TD]Mitchell Repair[/TD]
[TD]1131[/TD]
[TD]02-7200[/TD]
[TD]04/30/16[/TD]
[TD]81,102.36[/TD]
[TD]05/30/16[/TD]
[TD]81,102.36[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]81,102.36[/TD]
[/TR]
[TR]
[TD]OUC[/TD]
[TD]1194[/TD]
[TD]02-7197[/TD]
[TD]04/30/16[/TD]
[TD]20,000.00[/TD]
[TD]05/30/16[/TD]
[TD]20,000.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]20,000.00[/TD]
[/TR]
[TR]
[TD]Partners Health Care, Inc[/TD]
[TD]1198[/TD]
[TD]02-7219[/TD]
[TD]04/30/16[/TD]
[TD]422.10[/TD]
[TD]06/14/16[/TD]
[TD]422.10[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]422.10[/TD]
[/TR]
[TR]
[TD]Qantas Airways Limited[/TD]
[TD]1134[/TD]
[TD]2013-0303[/TD]
[TD]11/20/13[/TD]
[TD]1,755.57[/TD]
[TD]12/20/13[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]1,755.57[/TD]
[TD]1,755.57[/TD]
[/TR]
[TR]
[TD]Raytheon [/TD]
[TD]1215[/TD]
[TD]02-7182[/TD]
[TD]03/31/16[/TD]
[TD]14,747.50[/TD]
[TD]05/03/16[/TD]
[TD]14,747.50[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]14,747.50[/TD]
[/TR]
[TR]
[TD]Rolls Royce[/TD]
[TD]1136[/TD]
[TD]INV16-02-0001[/TD]
[TD]02/29/16[/TD]
[TD]99,631.37[/TD]
[TD]05/14/16[/TD]
[TD]99,631.37[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]99,631.37[/TD]
[/TR]
[TR]
[TD]RSI Content Solutions[/TD]
[TD]1173[/TD]
[TD]INV2016-0049[/TD]
[TD]04/15/16[/TD]
[TD]18,810.00[/TD]
[TD]05/15/16[/TD]
[TD]18,810.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]18,810.00[/TD]
[/TR]
[TR]
[TD]South Africa Airways SOC [/TD]
[TD]1140[/TD]
[TD]INV16-11488[/TD]
[TD]02/29/16[/TD]
[TD]7,797.00[/TD]
[TD]03/30/16[/TD]
[TD]0.00[/TD]
[TD]7,797.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]7,797.00[/TD]
[/TR]
[TR]
[TD]STV Incorporated[/TD]
[TD]1187[/TD]
[TD]02-7169[/TD]
[TD]03/31/16[/TD]
[TD]59,939.85[/TD]
[TD]05/30/16[/TD]
[TD]59,939.85[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]59,939.85[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]TE Connectivity[/TD]
[TD]1213[/TD]
[TD]02-7180R[/TD]
[TD]03/31/16[/TD]
[TD]82,790.00[/TD]
[TD]05/30/16[/TD]
[TD]82,790.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]82,790.00[/TD]
[/TR]
[TR]
[TD]United Airlines[/TD]
[TD]1144[/TD]
[TD]INV2016-0052[/TD]
[TD]04/21/16[/TD]
[TD]90,000.00[/TD]
[TD]05/21/16[/TD]
[TD]90,000.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]90,000.00[/TD]
[/TR]
[TR]
[TD]United Parcel Service [/TD]
[TD]1145[/TD]
[TD]INV16-11535[/TD]
[TD]03/31/16[/TD]
[TD]41,937.00[/TD]
[TD]05/15/16[/TD]
[TD]41,937.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]41,937.00[/TD]
[/TR]
[TR]
[TD]URS [/TD]
[TD]1085[/TD]
[TD]6285[/TD]
[TD]12/31/13[/TD]
[TD]160.00[/TD]
[TD]01/30/14[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]160.00[/TD]
[TD]160.00[/TD]
[/TR]
[TR]
[TD]Walt Disney Company[/TD]
[TD]1016[/TD]
[TD]02-7178[/TD]
[TD]03/31/16[/TD]
[TD]58,789.15[/TD]
[TD]04/30/16[/TD]
[TD]58,789.15[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]58,789.15[/TD]
[/TR]
[TR]
[TD]WebMD[/TD]
[TD]1153[/TD]
[TD]02-7196[/TD]
[TD]04/25/16[/TD]
[TD]5,890.00[/TD]
[TD]05/25/16[/TD]
[TD]5,890.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]5,890.00[/TD]
[/TR]
[TR]
[TD]Western Reserve Group[/TD]
[TD]1195[/TD]
[TD]02-7211[/TD]
[TD]04/30/16[/TD]
[TD]2,763.00[/TD]
[TD]05/30/16[/TD]
[TD]2,763.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]2,763.00[/TD]
[/TR]
[TR]
[TD]Whirlpool [/TD]
[TD]1079[/TD]
[TD]02-7116[/TD]
[TD]03/07/16[/TD]
[TD]520.00[/TD]
[TD]05/06/16[/TD]
[TD]520.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]520.00[/TD]
[/TR]
[TR]
[TD]Zodiac Seats US LLC[/TD]
[TD]1163[/TD]
[TD]INV2016-0054[/TD]
[TD]04/25/16[/TD]
[TD]12,275.81[/TD]
[TD]06/24/16[/TD]
[TD]12,275.81[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]12,275.81[/TD]
[/TR]
</tbody>[/TABLE]
Sheet 2
[TABLE="width: 481"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Owner [/TD]
[TD]Account #[/TD]
[TD]Name[/TD]
[TD]Payment Terms[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1206[/TD]
[TD]6300 La Calma Property, L[/TD]
[TD]DUE ON RECEIPT[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1186[/TD]
[TD]AirWatch[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1105[/TD]
[TD]American Airlines[/TD]
[TD]NET 45[/TD]
[/TR]
[TR]
[TD]Eric[/TD]
[TD]1102[/TD]
[TD]Applied Materials[/TD]
[TD]NET 60[/TD]
[/TR]
[TR]
[TD]Eric[/TD]
[TD]1103[/TD]
[TD]Applied Materials Baccini[/TD]
[TD]NET 45[/TD]
[/TR]
[TR]
[TD]Eric[/TD]
[TD]1101[/TD]
[TD]Applied Materials GmbH [/TD]
[TD]NET 45[/TD]
[/TR]
[TR]
[TD]Eric[/TD]
[TD]1149[/TD]
[TD]Applied Materials SE Asia[/TD]
[TD]NET 45[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1080[/TD]
[TD]ASTM[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1193[/TD]
[TD]BIS[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Mark/Eric[/TD]
[TD]1067[/TD]
[TD]Boeing[/TD]
[TD]NET 45[/TD]
[/TR]
[TR]
[TD]Mark/Eric[/TD]
[TD]1018[/TD]
[TD]Boeing Trust Investments[/TD]
[TD]NET 45[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1196[/TD]
[TD]Boston Capital[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1056[/TD]
[TD]Cambridge Assessment[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1199[/TD]
[TD]Capgemini[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1062[/TD]
[TD]Carters[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1110[/TD]
[TD]CDO Technologies, Inc[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1111[/TD]
[TD]CITEC[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1093[/TD]
[TD]CMPA[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]11203[/TD]
[TD]Collier County School[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1152[/TD]
[TD]Concentra[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1197[/TD]
[TD]Covance[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1164[/TD]
[TD]Credit Acceptance[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1205[/TD]
[TD]Cyient (Infotech)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1112[/TD]
[TD]Delta Air Lines, Inc[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1209[/TD]
[TD]DTE Gas Company [/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1202[/TD]
[TD]Eaton Vance Management[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1116[/TD]
[TD]Editions Francis Lefebvre[/TD]
[TD]NET 45[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1003[/TD]
[TD]EMC USA[/TD]
[TD]NET 60[/TD]
[/TR]
[TR]
[TD]Eric[/TD]
[TD]10152[/TD]
[TD]Esterline[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1207[/TD]
[TD]FLUOR-B&W Portsmouth[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1203[/TD]
[TD]FOKKER SERVICES B.V.[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1122[/TD]
[TD]Freescale Semiconductor[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Eric/Mark[/TD]
[TD]1123[/TD]
[TD]General Electric Company[/TD]
[TD]NET 120[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1190[/TD]
[TD]Graybar[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1191[/TD]
[TD]HarbourVest[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Eric[/TD]
[TD]1124[/TD]
[TD]Honeywell[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1128[/TD]
[TD]Intergraph Govt Solutions[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1169[/TD]
[TD]International Aero Engin[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1167[/TD]
[TD]Japanses Aero Engine Corp[/TD]
[TD]30D[/TD]
[/TR]
[TR]
[TD]Eric[/TD]
[TD]1129[/TD]
[TD]Korry Electronics [/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1214[/TD]
[TD]LA County-EMC[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1154[/TD]
[TD]Latam[/TD]
[TD]NET 45[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1170[/TD]
[TD]LMI Aerospace, Inc.[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1212[/TD]
[TD]Loomis Sayles[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1005[/TD]
[TD]McGraw Hill[/TD]
[TD]NET 45[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1148[/TD]
[TD]Mediaocean[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1219[/TD]
[TD]Medicinova[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1211[/TD]
[TD]Metalogix[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1216[/TD]
[TD]MFS Investments[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1131[/TD]
[TD]Mitchell Repair[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1098[/TD]
[TD]Nebraska Legislative Coun[/TD]
[TD]NET 45[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1029[/TD]
[TD]O.C. Tanner[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1194[/TD]
[TD]OUC[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1198[/TD]
[TD]Partners Health Care, Inc[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1161[/TD]
[TD]Pinnacle Solutions Inc.[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1077[/TD]
[TD]Rally Software[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1215[/TD]
[TD]Raytheon [/TD]
[TD]NET 33[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1136[/TD]
[TD]Rolls Royce[/TD]
[TD]NET 60[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1173[/TD]
[TD]RSI Content Solutions[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1221[/TD]
[TD]Sage Insights[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Eric[/TD]
[TD]1140[/TD]
[TD]South Africa Airways SOC [/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1141[/TD]
[TD]Southwest Airlines[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1187[/TD]
[TD]STV Incorporated[/TD]
[TD]NET 60[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1156[/TD]
[TD]TAM Linhas Aereas[/TD]
[TD]NET 45[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1213[/TD]
[TD]TE Connectivity[/TD]
[TD]NET 60[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1218[/TD]
[TD]Telair US LLC[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1208[/TD]
[TD]Texas Health Physicians[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Mark/Eric[/TD]
[TD]1166[/TD]
[TD]The Boeing Company[/TD]
[TD]30D[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1142[/TD]
[TD]Time Inc IT Purchasing[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1144[/TD]
[TD]United Airlines[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1145[/TD]
[TD]United Parcel Service [/TD]
[TD]NET 45[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1104[/TD]
[TD]US Airways[/TD]
[TD]NET 45[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1016[/TD]
[TD]Walt Disney Company[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1153[/TD]
[TD]WebMD[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1195[/TD]
[TD]Western Reserve Group[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1079[/TD]
[TD]Whirlpool [/TD]
[TD]NET 60[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1176[/TD]
[TD]Zodiac Cabin Interiors[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1163[/TD]
[TD]Zodiac Seats US LLC[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I have 2 work sheets in which I need to extract which employee works on which customer. The common denominator for both worksheets is "Account#" in which I can do a Vlookup but it still does not really help since couple customer belong to multiple employees.
Each employee has their own invoice number convention. (Mark="Inv2016"), (Amy="02-"), Eric ("INV").
Can someone please assist on which formula will help to extract the correct employee working to their particular project?
Sheet 1
[TABLE="width: 1105"]
<colgroup><col><col><col><col><col><col><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD]Customer Name[/TD]
[TD]Account #[/TD]
[TD]Invoice Number[/TD]
[TD]Invoice Date[/TD]
[TD]Invoice Amount[/TD]
[TD]Due Date[/TD]
[TD]Current[/TD]
[TD]31 to 60[/TD]
[TD]61 to 90[/TD]
[TD]Over 90[/TD]
[TD]Balance Due[/TD]
[/TR]
[TR]
[TD]American Airlines[/TD]
[TD]1105[/TD]
[TD]INV15-11230[/TD]
[TD]10/31/15[/TD]
[TD]5,405.00[/TD]
[TD]12/15/15[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]5,405.00[/TD]
[TD]5,405.00[/TD]
[/TR]
[TR]
[TD]Applied Materials[/TD]
[TD]1102[/TD]
[TD]INV16-11425[/TD]
[TD]01/31/16[/TD]
[TD]337.50[/TD]
[TD]03/31/16[/TD]
[TD]0.00[/TD]
[TD]337.50[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]337.50[/TD]
[/TR]
[TR]
[TD]Applied Materials GmbH [/TD]
[TD]1101[/TD]
[TD]INV16-11483[/TD]
[TD]02/29/16[/TD]
[TD]30,546.20[/TD]
[TD]04/29/16[/TD]
[TD]30,546.20[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]30,546.20[/TD]
[/TR]
[TR]
[TD]Applied Materials SE Asia[/TD]
[TD]1149[/TD]
[TD]INV16-11532[/TD]
[TD]03/31/16[/TD]
[TD]892.00[/TD]
[TD]05/30/16[/TD]
[TD]892.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]892.00[/TD]
[/TR]
[TR]
[TD]BIS[/TD]
[TD]1193[/TD]
[TD]02-7170[/TD]
[TD]03/31/16[/TD]
[TD]96,325.64[/TD]
[TD]04/30/16[/TD]
[TD]96,325.64[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]96,325.64[/TD]
[/TR]
[TR]
[TD]Boeing[/TD]
[TD]1067[/TD]
[TD]02-7014R[/TD]
[TD]11/30/15[/TD]
[TD]2,400.00[/TD]
[TD]01/14/16[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](1,680.00)[/TD]
[TD](1,680.00)[/TD]
[/TR]
[TR]
[TD]Boston Capital[/TD]
[TD]1196[/TD]
[TD]02-7230[/TD]
[TD]04/30/16[/TD]
[TD]8,775.00[/TD]
[TD]05/30/16[/TD]
[TD]8,775.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]8,775.00[/TD]
[/TR]
[TR]
[TD]CDO Technologies, Inc[/TD]
[TD]1110[/TD]
[TD]I14-5018[/TD]
[TD]06/06/14[/TD]
[TD]1,893.10[/TD]
[TD]07/06/14[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]1,893.10[/TD]
[TD]1,893.10[/TD]
[/TR]
[TR]
[TD]Collier County School[/TD]
[TD]11203[/TD]
[TD]02-7215[/TD]
[TD]04/30/16[/TD]
[TD]199.00[/TD]
[TD]05/30/16[/TD]
[TD]199.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]199.00[/TD]
[/TR]
[TR]
[TD]Concentra[/TD]
[TD]1152[/TD]
[TD]02-7198[/TD]
[TD]04/30/16[/TD]
[TD]105,700.00[/TD]
[TD]05/30/16[/TD]
[TD]105,700.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]105,700.00[/TD]
[/TR]
[TR]
[TD]Delta Air Lines, Inc[/TD]
[TD]1112[/TD]
[TD]INV2016-0045[/TD]
[TD]04/13/16[/TD]
[TD]4,375.00[/TD]
[TD]05/28/16[/TD]
[TD]4,375.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]4,375.00[/TD]
[/TR]
[TR]
[TD]DTE Gas Company [/TD]
[TD]1209[/TD]
[TD]02-7186[/TD]
[TD]03/31/16[/TD]
[TD]24,453.00[/TD]
[TD]04/30/16[/TD]
[TD]24,453.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]24,453.00[/TD]
[/TR]
[TR]
[TD]Eaton Vance Management[/TD]
[TD]1202[/TD]
[TD]02-7213[/TD]
[TD]04/30/16[/TD]
[TD]2,940.00[/TD]
[TD]05/30/16[/TD]
[TD]2,940.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]2,940.00[/TD]
[/TR]
[TR]
[TD]Editions Francis Lefebvre[/TD]
[TD]1116[/TD]
[TD]02-7155[/TD]
[TD]03/30/16[/TD]
[TD]56,500.00[/TD]
[TD]05/14/16[/TD]
[TD]56,500.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]56,500.00[/TD]
[/TR]
[TR]
[TD]EMC USA[/TD]
[TD]1003[/TD]
[TD]02-6917[/TD]
[TD]09/30/15[/TD]
[TD]30,750.00[/TD]
[TD]11/29/15[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]30,750.00[/TD]
[TD]30,750.00[/TD]
[/TR]
[TR]
[TD]EMS Aviation Inc[/TD]
[TD]1117[/TD]
[TD]INV16-11466[/TD]
[TD]01/31/16[/TD]
[TD]1,372.00[/TD]
[TD]04/30/16[/TD]
[TD]1,372.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]1,372.00[/TD]
[/TR]
[TR]
[TD]General Electric Company[/TD]
[TD]1123[/TD]
[TD]02-7232[/TD]
[TD]04/30/16[/TD]
[TD]15,404.24[/TD]
[TD]08/28/16[/TD]
[TD]15,404.24[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]15,404.24[/TD]
[/TR]
[TR]
[TD]Honeywell[/TD]
[TD]1124[/TD]
[TD]13-10073[/TD]
[TD]10/31/13[/TD]
[TD]15,090.00[/TD]
[TD]01/29/14[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[/TR]
[TR]
[TD]Korry Electronics [/TD]
[TD]1129[/TD]
[TD]13-10087[/TD]
[TD]10/31/13[/TD]
[TD]76,265.40[/TD]
[TD]11/30/13[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]177.75[/TD]
[TD]177.75[/TD]
[/TR]
[TR]
[TD]Malaysia Airlines[/TD]
[TD]1130[/TD]
[TD]2012-0141[/TD]
[TD]06/01/12[/TD]
[TD]9,362.50[/TD]
[TD]07/01/12[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]9,362.50[/TD]
[TD]9,362.50[/TD]
[/TR]
[TR]
[TD]McGraw Hill[/TD]
[TD]1005[/TD]
[TD]02-7154[/TD]
[TD]03/29/16[/TD]
[TD]215,888.75[/TD]
[TD]05/13/16[/TD]
[TD]215,888.75[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]215,888.75[/TD]
[/TR]
[TR]
[TD]Medicinova[/TD]
[TD]1219[/TD]
[TD]02-7107[/TD]
[TD]02/23/16[/TD]
[TD]6,053.85[/TD]
[TD]03/24/16[/TD]
[TD]0.00[/TD]
[TD]6,053.85[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]6,053.85[/TD]
[/TR]
[TR]
[TD]Mitchell Repair[/TD]
[TD]1131[/TD]
[TD]02-7200[/TD]
[TD]04/30/16[/TD]
[TD]81,102.36[/TD]
[TD]05/30/16[/TD]
[TD]81,102.36[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]81,102.36[/TD]
[/TR]
[TR]
[TD]OUC[/TD]
[TD]1194[/TD]
[TD]02-7197[/TD]
[TD]04/30/16[/TD]
[TD]20,000.00[/TD]
[TD]05/30/16[/TD]
[TD]20,000.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]20,000.00[/TD]
[/TR]
[TR]
[TD]Partners Health Care, Inc[/TD]
[TD]1198[/TD]
[TD]02-7219[/TD]
[TD]04/30/16[/TD]
[TD]422.10[/TD]
[TD]06/14/16[/TD]
[TD]422.10[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]422.10[/TD]
[/TR]
[TR]
[TD]Qantas Airways Limited[/TD]
[TD]1134[/TD]
[TD]2013-0303[/TD]
[TD]11/20/13[/TD]
[TD]1,755.57[/TD]
[TD]12/20/13[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]1,755.57[/TD]
[TD]1,755.57[/TD]
[/TR]
[TR]
[TD]Raytheon [/TD]
[TD]1215[/TD]
[TD]02-7182[/TD]
[TD]03/31/16[/TD]
[TD]14,747.50[/TD]
[TD]05/03/16[/TD]
[TD]14,747.50[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]14,747.50[/TD]
[/TR]
[TR]
[TD]Rolls Royce[/TD]
[TD]1136[/TD]
[TD]INV16-02-0001[/TD]
[TD]02/29/16[/TD]
[TD]99,631.37[/TD]
[TD]05/14/16[/TD]
[TD]99,631.37[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]99,631.37[/TD]
[/TR]
[TR]
[TD]RSI Content Solutions[/TD]
[TD]1173[/TD]
[TD]INV2016-0049[/TD]
[TD]04/15/16[/TD]
[TD]18,810.00[/TD]
[TD]05/15/16[/TD]
[TD]18,810.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]18,810.00[/TD]
[/TR]
[TR]
[TD]South Africa Airways SOC [/TD]
[TD]1140[/TD]
[TD]INV16-11488[/TD]
[TD]02/29/16[/TD]
[TD]7,797.00[/TD]
[TD]03/30/16[/TD]
[TD]0.00[/TD]
[TD]7,797.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]7,797.00[/TD]
[/TR]
[TR]
[TD]STV Incorporated[/TD]
[TD]1187[/TD]
[TD]02-7169[/TD]
[TD]03/31/16[/TD]
[TD]59,939.85[/TD]
[TD]05/30/16[/TD]
[TD]59,939.85[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]59,939.85[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]TE Connectivity[/TD]
[TD]1213[/TD]
[TD]02-7180R[/TD]
[TD]03/31/16[/TD]
[TD]82,790.00[/TD]
[TD]05/30/16[/TD]
[TD]82,790.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]82,790.00[/TD]
[/TR]
[TR]
[TD]United Airlines[/TD]
[TD]1144[/TD]
[TD]INV2016-0052[/TD]
[TD]04/21/16[/TD]
[TD]90,000.00[/TD]
[TD]05/21/16[/TD]
[TD]90,000.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]90,000.00[/TD]
[/TR]
[TR]
[TD]United Parcel Service [/TD]
[TD]1145[/TD]
[TD]INV16-11535[/TD]
[TD]03/31/16[/TD]
[TD]41,937.00[/TD]
[TD]05/15/16[/TD]
[TD]41,937.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]41,937.00[/TD]
[/TR]
[TR]
[TD]URS [/TD]
[TD]1085[/TD]
[TD]6285[/TD]
[TD]12/31/13[/TD]
[TD]160.00[/TD]
[TD]01/30/14[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]160.00[/TD]
[TD]160.00[/TD]
[/TR]
[TR]
[TD]Walt Disney Company[/TD]
[TD]1016[/TD]
[TD]02-7178[/TD]
[TD]03/31/16[/TD]
[TD]58,789.15[/TD]
[TD]04/30/16[/TD]
[TD]58,789.15[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]58,789.15[/TD]
[/TR]
[TR]
[TD]WebMD[/TD]
[TD]1153[/TD]
[TD]02-7196[/TD]
[TD]04/25/16[/TD]
[TD]5,890.00[/TD]
[TD]05/25/16[/TD]
[TD]5,890.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]5,890.00[/TD]
[/TR]
[TR]
[TD]Western Reserve Group[/TD]
[TD]1195[/TD]
[TD]02-7211[/TD]
[TD]04/30/16[/TD]
[TD]2,763.00[/TD]
[TD]05/30/16[/TD]
[TD]2,763.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]2,763.00[/TD]
[/TR]
[TR]
[TD]Whirlpool [/TD]
[TD]1079[/TD]
[TD]02-7116[/TD]
[TD]03/07/16[/TD]
[TD]520.00[/TD]
[TD]05/06/16[/TD]
[TD]520.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]520.00[/TD]
[/TR]
[TR]
[TD]Zodiac Seats US LLC[/TD]
[TD]1163[/TD]
[TD]INV2016-0054[/TD]
[TD]04/25/16[/TD]
[TD]12,275.81[/TD]
[TD]06/24/16[/TD]
[TD]12,275.81[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]12,275.81[/TD]
[/TR]
</tbody>[/TABLE]
Sheet 2
[TABLE="width: 481"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Owner [/TD]
[TD]Account #[/TD]
[TD]Name[/TD]
[TD]Payment Terms[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1206[/TD]
[TD]6300 La Calma Property, L[/TD]
[TD]DUE ON RECEIPT[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1186[/TD]
[TD]AirWatch[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1105[/TD]
[TD]American Airlines[/TD]
[TD]NET 45[/TD]
[/TR]
[TR]
[TD]Eric[/TD]
[TD]1102[/TD]
[TD]Applied Materials[/TD]
[TD]NET 60[/TD]
[/TR]
[TR]
[TD]Eric[/TD]
[TD]1103[/TD]
[TD]Applied Materials Baccini[/TD]
[TD]NET 45[/TD]
[/TR]
[TR]
[TD]Eric[/TD]
[TD]1101[/TD]
[TD]Applied Materials GmbH [/TD]
[TD]NET 45[/TD]
[/TR]
[TR]
[TD]Eric[/TD]
[TD]1149[/TD]
[TD]Applied Materials SE Asia[/TD]
[TD]NET 45[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1080[/TD]
[TD]ASTM[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1193[/TD]
[TD]BIS[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Mark/Eric[/TD]
[TD]1067[/TD]
[TD]Boeing[/TD]
[TD]NET 45[/TD]
[/TR]
[TR]
[TD]Mark/Eric[/TD]
[TD]1018[/TD]
[TD]Boeing Trust Investments[/TD]
[TD]NET 45[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1196[/TD]
[TD]Boston Capital[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1056[/TD]
[TD]Cambridge Assessment[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1199[/TD]
[TD]Capgemini[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1062[/TD]
[TD]Carters[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1110[/TD]
[TD]CDO Technologies, Inc[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1111[/TD]
[TD]CITEC[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1093[/TD]
[TD]CMPA[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]11203[/TD]
[TD]Collier County School[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1152[/TD]
[TD]Concentra[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1197[/TD]
[TD]Covance[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1164[/TD]
[TD]Credit Acceptance[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1205[/TD]
[TD]Cyient (Infotech)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1112[/TD]
[TD]Delta Air Lines, Inc[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1209[/TD]
[TD]DTE Gas Company [/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1202[/TD]
[TD]Eaton Vance Management[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1116[/TD]
[TD]Editions Francis Lefebvre[/TD]
[TD]NET 45[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1003[/TD]
[TD]EMC USA[/TD]
[TD]NET 60[/TD]
[/TR]
[TR]
[TD]Eric[/TD]
[TD]10152[/TD]
[TD]Esterline[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1207[/TD]
[TD]FLUOR-B&W Portsmouth[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1203[/TD]
[TD]FOKKER SERVICES B.V.[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1122[/TD]
[TD]Freescale Semiconductor[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Eric/Mark[/TD]
[TD]1123[/TD]
[TD]General Electric Company[/TD]
[TD]NET 120[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1190[/TD]
[TD]Graybar[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1191[/TD]
[TD]HarbourVest[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Eric[/TD]
[TD]1124[/TD]
[TD]Honeywell[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1128[/TD]
[TD]Intergraph Govt Solutions[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1169[/TD]
[TD]International Aero Engin[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1167[/TD]
[TD]Japanses Aero Engine Corp[/TD]
[TD]30D[/TD]
[/TR]
[TR]
[TD]Eric[/TD]
[TD]1129[/TD]
[TD]Korry Electronics [/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1214[/TD]
[TD]LA County-EMC[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1154[/TD]
[TD]Latam[/TD]
[TD]NET 45[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1170[/TD]
[TD]LMI Aerospace, Inc.[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1212[/TD]
[TD]Loomis Sayles[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1005[/TD]
[TD]McGraw Hill[/TD]
[TD]NET 45[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1148[/TD]
[TD]Mediaocean[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1219[/TD]
[TD]Medicinova[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1211[/TD]
[TD]Metalogix[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1216[/TD]
[TD]MFS Investments[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1131[/TD]
[TD]Mitchell Repair[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1098[/TD]
[TD]Nebraska Legislative Coun[/TD]
[TD]NET 45[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1029[/TD]
[TD]O.C. Tanner[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1194[/TD]
[TD]OUC[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1198[/TD]
[TD]Partners Health Care, Inc[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1161[/TD]
[TD]Pinnacle Solutions Inc.[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1077[/TD]
[TD]Rally Software[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1215[/TD]
[TD]Raytheon [/TD]
[TD]NET 33[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1136[/TD]
[TD]Rolls Royce[/TD]
[TD]NET 60[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1173[/TD]
[TD]RSI Content Solutions[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1221[/TD]
[TD]Sage Insights[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Eric[/TD]
[TD]1140[/TD]
[TD]South Africa Airways SOC [/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1141[/TD]
[TD]Southwest Airlines[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1187[/TD]
[TD]STV Incorporated[/TD]
[TD]NET 60[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1156[/TD]
[TD]TAM Linhas Aereas[/TD]
[TD]NET 45[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1213[/TD]
[TD]TE Connectivity[/TD]
[TD]NET 60[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1218[/TD]
[TD]Telair US LLC[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1208[/TD]
[TD]Texas Health Physicians[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Mark/Eric[/TD]
[TD]1166[/TD]
[TD]The Boeing Company[/TD]
[TD]30D[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1142[/TD]
[TD]Time Inc IT Purchasing[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1144[/TD]
[TD]United Airlines[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1145[/TD]
[TD]United Parcel Service [/TD]
[TD]NET 45[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1104[/TD]
[TD]US Airways[/TD]
[TD]NET 45[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1016[/TD]
[TD]Walt Disney Company[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1153[/TD]
[TD]WebMD[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1195[/TD]
[TD]Western Reserve Group[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1079[/TD]
[TD]Whirlpool [/TD]
[TD]NET 60[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1176[/TD]
[TD]Zodiac Cabin Interiors[/TD]
[TD]NET 30[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]1163[/TD]
[TD]Zodiac Seats US LLC[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]