The sales rep commission rate varies for each sales rep. In column D, Doug used a VLOOKUP function to look up the commission rate for each sales rep, and then multiplied the commission rate by the invoice amount to calculate the commission. Although the first two rows in column D of the Excel table named Aging display the correct commission, all the other cells display #N/A. Find the problem with the formulas in the Commission column and fix it

Below are invoice table and the Commission Rates table for each sale rep. Also the Vlookup formula =VLOOKUP(C6,Commission!A6:B9,2)*F6

Invoice Nbr

Company

Sales Rep

Sales Rep Commission

Invoice Date

Invoice Amount

Days Past Due

Current

1-30 days

31-60 days

61-90 days

Over 90 days

10269	Coalescent Technologies Corporation	Bright	$ 50.70	6/2/2016	$ 676.00
10273	Consortium for Ocean Leadership	Hamilton	$ 128.54	5/28/2016	$ 2,142.40
10274	Grow Smart Delaware	Hamilton	#N/A	6/5/2016	$ 538.60
10282	MRSI Group, Inc	Bright	#N/A	6/9/2016	$ 155.40
10283	Natural Environment Research Co	Newton	#N/A	6/12/2016	$ 1,414.80
10291	Normandeau & Associates	Bright	#N/A	5/17/2016	$ 552.80
10321	Alpharma,Inc	Newton	#N/A	5/5/2016	$ 144.00
10322	Alternatives Res & Dev Fdtn	Bright	#N/A	5/7/2016	$ 112.00
10323	Cardio Tech International Inc.	Bright	#N/A	5/8/2016	$ 164.40
10327	Citizens for the Protection of Waverly Bay	Roberts	#N/A	6/10/2016	$ 2,262.50
10329	Image Acoustics, Inc.	Newton	#N/A	6/27/2016	$ 4,819.40
10356	New Mexico Regional Turf Foundation	Bright	#N/A	5/29/2016	$ 1,106.40
10358	Ocean Dynamics Inc.	Bright	#N/A	6/2/2016	$ 452.00
10368	Synergy Innovations, Inc.	Bright	#N/A	6/6/2016	$ 1,834.20
10370	Materials Sciences Corporation	Hamilton	#N/A	5/5/2016	$ 1,174.00
10395	Ekloff Marine Corp.	Hamilton	#N/A	1/26/2016	$ 2,333.20
10400	Hazen Research Inc.	Bright	#N/A	6/1/2016	$ 3,063.00
10401	I. M. A. Dynamite Group, Inc.	Bright	#N/A	6/1/2016	$ 3,868.60
10406	Mikel, Inc.	Hamilton	#N/A	2/7/2016	$ 2,018.20
10407	Marine BioConversion, LLC	Roberts	#N/A	2/7/2016	$ 1,194.00
10410	New Medical Center	Bright	#N/A	5/10/2016	$ 802.00
10413	Advanced Scientific Concepts, Inc.	Newton	#N/A	6/16/2016	$ 2,123.20
10418	American Heart Association	Newton	#N/A	5/17/2016	$ 1,814.80
10430	Foster Corporation	Bright	#N/A	5/2/2016	$ 5,796.00
10432	Jet Propulsion Laboratory	Bright	#N/A	5/5/2016	$ 485.00
10436	Lyme Disease Assoc of NJ	Bright	#N/A	5/8/2016	$ 2,210.80
10439	Institute for Research & Evaluation	Bright	#N/A	5/10/2016	$ 1,078.00
10443	Lincoln Institute of Policy	Newton	#N/A	6/15/2016	$ 537.60
10463	Pro Change Behavior Systems	Hamilton	#N/A	6/6/2016	$ 713.30
10471	American Psychology Foundation	Newton	#N/A	6/11/2016	$ 1,328.00
10473	Boston Medical Center	Roberts	#N/A	6/15/2016	$ 230.40
10476	CSCS Corp.	Roberts	#N/A	6/17/2016	$ 182.40
10480	Promire Gas Company	Newton	#N/A	5/20/2016	$ 756.00
10482	Shire Development Inc.	Newton	#N/A	6/21/2016	$ 147.00
10483	Global Environment & Technology Foundation	Newton	#N/A	5/26/2016	$ 704.00
10484	Argonne National Laboratories	Newton	#N/A	6/26/2016	$ 386.20
10496	Lake Simco Conservation Authority	Newton	#N/A	5/5/2016	$ 200.00
10500	Perry Institute for Marine Science	Bright	#N/A	5/10/2016	$ 550.80
10502	Save the Lions	Hamilton	#N/A	5/11/2016	$ 816.30
10520	Army Corp	Hamilton	#N/A	4/30/2016	$ 200.00
10527	Cape Cod National Seashore NPS	Hamilton	#N/A	6/5/2016	$ 1,670.00
10539	Emitech	Newton	#N/A	6/16/2016	$ 355.50
10551	Genix Therapeutics, Inc.	Newton	#N/A	6/28/2016	$ 1,836.00
10559	Nationa Park and Recreation	Bright	#N/A	6/6/2016	$ 547.80
10566	NM State Agricultural Experiment Station	Newton	#N/A	6/15/2016	$ 2,040.00
10567	Northeast Fisheries Science Center	Newton	#N/A	6/15/2016	$ 3,109.00
10571	SAECT	Newton	#N/A	6/18/2016	$ 647.75
10575	Environ Protection Agcy	Roberts	#N/A	6/21/2016	$ 2,147.40
10577	Altuna International Research Co.	Newton	#N/A	6/26/2016	$ 569.00
10578	Bigelow Laboratory for Mining	Newton	#N/A	6/25/2016	$ 477.00
10586	BoBell Flavors, Inc	Hamilton	#N/A	5/20/2016	$ 28.00
10588	Brossman Engineering	Bright	#N/A	5/28/2016	$ 3,900.00
10589	Cadmus Group	Hamilton	#N/A	5/29/2016	$ 72.00
10590	Catalyst Foundation	Newton	#N/A	5/30/2016	$ 1,140.00
10622	Evans Hamilton Inc.	Newton	#N/A	6/2/2016	$ 605.00
10623	Intervet International B.V.	Hamilton	#N/A	6/5/2016	$ 1,429.75
10625	Laser Fare Advanced Technology Group	Newton	#N/A	6/6/2016	$ 479.75
10629	Medical Tech International, Inc	Newton	#N/A	6/5/2016	$ 2,775.05
10640	NOMAD Limited	Bright	#N/A	6/15/2016	$ 945.00
10667	Northeast Regional Aquaculture Center	Hamilton	#N/A	5/25/2016	$ 1,921.00
10671	Sensor Tech, Inc.	Bright	#N/A	6/8/2016	$ 920.10
10676	Sino Development Corporation Ltd.	Bright	#N/A	6/15/2016	$ 534.85
10678	SORICO	Bright	#N/A	6/18/2016	$ 5,256.50
10686	Swedish Board of Fisheries SBF	Bright	#N/A	6/16/2016	$ 1,638.45
10687	St Jeremy Hospital	Roberts	#N/A	6/19/2016	$ 6,201.90
10689	Acquisition Center	Bright	#N/A	5/6/2016	$ 630.00
10702	FM Global Research	Bright	#N/A	6/25/2016	$ 330.00
10707	Lamont-Doherty Earth Observatory	Roberts	#N/A	6/29/2016	$ 1,704.00
10741	Lemelson Foundation - NCIIA	Newton	#N/A	6/30/2016	$ 285.00
10760	Conrad	Hamilton	#N/A	5/21/2016	$ 3,304.00
10763	Nalas Engineering Services, Inc.	Newton	#N/A	6/5/2016	$ 616.00
10768	Tetra Tech	Newton	#N/A	1/8/2016	$ 1,477.00
10776	Chemo International Inc.	Bright	#N/A	6/15/2016	$ 6,984.50
10787	Child Wilfare Institute	Bright	#N/A	1/19/2016	$ 2,760.80
10790	Ecochlor	Roberts	#N/A	5/22/2016	$ 850.00
10807	Emitech, Inc	Hamilton	#N/A	5/31/2016	$ 18.40
10815	Kent Electric	Newton	#N/A	5/5/2016	$ 40.00
10831	American Cancer Society	Bright	#N/A	6/16/2016	$ 2,684.40
10840	DHS Medical Assistance	Bright	#N/A	6/19/2016	$ 264.00
10858	EA Engineering, Science & Technology, Inc.	Hamilton	#N/A	2/29/2016	$ 649.00
10864	KM Scientific Company	Hamilton	#N/A	5/6/2016	$ 282.00
10881	Russell Wisdom Foundation	Bright	#N/A	5/15/2016	$ 150.00
10887	Eknor Apex Company	Roberts	#N/A	5/15/2016	$ 70.00
10907	Maxwell Technologies	Bright	#N/A	5/27/2016	$ 108.50
10926	Memory Pharmaceuticals, Inc	Hamilton	#N/A	6/5/2016	$ 514.40
10935	Alaska Department of Fish & Game	Bright	#N/A	6/8/2016	$ 700.00
10946	Ardane Therapeutics	Hamilton	#N/A	6/11/2016	$ 1,407.50
10957	Frontier Technology. Inc.	Newton	#N/A	4/17/2016	$ 1,762.70
10960	Institute of Technology	Hamilton	#N/A	6/18/2016	$ 276.60
10962	Merck Sharp & Dohme Corp.	Bright	#N/A	4/18/2016	$ 3,584.00
10963	GreenFins LLC	Bright	#N/A	6/18/2016	$ 68.00
10966	Pam Roddick Housing Authority	Newton	#N/A	6/19/2016	$ 1,255.60
10967	The Armore Corporation	Bright	#N/A	6/22/2016	$ 910.40
10982	Hudson River group	Hamilton	#N/A	6/26/2016	$ 1,014.00
10996	IODP Management International, Inc	Newton	#N/A	5/2/2016	$ 560.00
10998	IUCN-Washington Office	Newton	#N/A	3/5/2016	$ 686.00
11007	Optodot Corporation	Bright	#N/A	5/8/2016	$ 2,633.90
11026	Adaptive Methods, Inc.	Hamilton	#N/A	3/15/2016	$ 1,030.00
11037	Advanced Fuel Research	Hamilton	#N/A	5/21/2016	$ 60.00
11064	BAE Systems	Roberts	#N/A	5/31/2016	$ 4,722.30
11068	Baylor Research Institute	Bright	#N/A	6/5/2016	$ 2,384.80
11069	CACI Technologies, Inc.	Bright	#N/A	3/5/2016	$ 360.00

Commission Rates
Bright	7.50%
Hamilton	6%
Newton	4%
Roberts	5.50%