Hi Please see my worksheet and the instructions in the separate attachment. 

I am completely stuck on the vlookup item (#6) and don't know exactly how the build the formula. Please review and assist. 

 

Thanks

 

Assignment 6 Colorado TripNameReginald RousseauDate2/28/2017

Emp NameJob TitleDate HiredSale AmountComm RateComm AmoutA. BakerStaff1/6/2009$13,985M. ChamberlinStaff5/8/2013$14,893T. TurnerSenior9/12/2011$33,945S. DavisAssociate11/25/2011$24,508Y. ErnestStaff8/2/2010$65,980F. GleasonSenior2/9/2007$42,674D. JamesStaff3/7/2012$35,780P. MattisonSenior6/9/2011$23,562T. ThomasAssociate5/5/2012$29,870H. HuntStaff9/12/2012$30,000K. EnofeSenior1/1/2015$25,000G. ScottAssociate1/8/2011$18,860E. JonesStaff9/8/2010$36,078J. HuntSenior3/2/2011$8,990K. GatesStaff5/5/2012$12,900D. DuncanAssociate6/6/2010$54,855J. HueSenior3/4/2009$18,450M. DoubStaff10/15/2013$25,902F. HartmanAssociate11/1/2011$40,000M. ReynoldsStaff1/1/2012$26,800D. GlemanSenior2/6/2013$35,560Commission Table

SaleBonus00100000.03200000.05300000.06400000.07500000.08600000.09700000.1SalaryAssociateSen$54,500.00 $

RegionNew RegionSalaryTotal PayEastSouthNorthEastSouthWestWestNorthNorthEastEastWestEastNorthSouthNorthEastSouthWestEastSouthMinimumAverageMaximum

niorStaf46,500.00 $38,500.00

Trip ID30023003300930103050310731423179RiverArkansas RArkansas RArkansas RColorado RColorado RArkansas RColorado RArkansas R# of Person8101217422205TripDays0.50.50.525111Fee/Person$45.00$40.00$45.00$180.00$125.00$75.00$85.00$85.00Colorado Trip Lookup TableEnter a Trip IDRiver# of PersonTripDaysTrip FeeDiscountTotalSP17

3190320432223395348835033515352936113628Arkansas RArkansas RColorado RArkansas RArkansas RColorado RColorado RSouth PlaTClear CreekClear Creek1892325718251092010.5212130.50.51$70.00$85.00$225.00$145.00$199.00$80.00$360.00$35.00$45.00$95.00

36703675South PlaTColorado River (Grand Canyon)18312.5$75.00$215.00

• 1494468203-Reginald Rousseau A6 Colorado Trip Lookup.xlsx
• 1494468203-sAssignment 6 Colorado Trip Instruction SP17 1.docx

ComputerScienceExpert

(11)

Status NEW Posted 11 May 2017 02:05 AM My Price 11.00

-----------

Attachments

file 1494468208-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer