Transactions transid acctnum 3474 5022 3475 5030 3476

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ons TransID AcctNum 3474 5022 3475 5030 3476 5055 3477 5053 3478 5055 3479 5022 3480 5052 3481 5020 3482 5053 3483 5051 Date 9/30/2013 1/30/2013 6/19/2013 7/20/2013 6/28/2013 2/17/2013 5/25/2013 12/6/2013 1/24/2013 6/27/2013 Chart of Accounts AcctNum AcctName 5020 Wages 5021 Salary 5022 Overhead 5030 Office supplies 5040 Marketing 5041 Trade shows 5050 Computer software 5051 Small office equipment 5052 Postage 5053 Telephone 5054 Internet 5055 Travel 5056 Meals and Entertainment Amount $18,253 $6,250 $10,696 $13,181 $10,221 $6,700 $5,045 $12,921 $14,634 $1,125 AcctName Exercise 4: VLOOKUP w/Tables Please perform the following: Convert the Customer List below to a Table named tbl_customers Populate the Cust Name and Cust State Transaction columns using a VLOOKUP function Be sure to use the Table's name in the VLOOKUP function Transactions CustID POL412 LHC001 EBD220 RAM101 QEX711 DIG290 POL412 NEW011 STR202 HBC160 ATM201 QCM550 POL412 Date 5/4/2013 7/3/2013 9/21/2013 8/28/2013 3/15/2013 5/1/2013 7/10/2013 9/9/2013 12/16/2013 9/27/2013 9/26/2013 10/17/2013 6/16/2013 Amount $821 $12,336 $15,051 $13,966 $9,737 $4,423 $16,311 $6,025 $16,815 $5,869 $4,026 $5,999 $15,396 Customer List CustID RAM101 DIG290 HBC160 EIN405 QCM550 QEX711 SAT017 NEW011 PBS408 STR202 POL412 LHC001 ATM201 UPS102 EBD220 STA301 DOP090 GRA182 Cust Name Cust State Ramsey Electronics CA Digital Media, Inc. AZ Hubble Contracting NY AE Time MN Quantum Computers IA Quark Express SD Strings and Things, Inc. HI Newton Apples MI Physics Book Supply PA Star Gazers LLC FL Polaris Enterprises ID Electron LHC TX Atom Miniatures IL Up Spin CA Entangled By Design WI Space Time Adventures RI Doppler Sound, Inc. WY Greene Audio CO Cust Name Cust State Exercise 5: Please perform the following: First, complete the set up as requested on the Exercise 5 Data worksheet. Set up data validation on the Dept Num input cell to allow a list =dd_depts (the name set up on the Exercise 5 sheet). Write a lookup function that will populate the Dept Name cell below, based on the user's Dept Num selection. Note: be sure your lo...
View Full Document

Ask a homework question - tutors are online