Extracting Data from another sheet.

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]
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top